Excel Gurus: I need your help.

[gbz]

I have a 3 page workbook.

On page one is a formula it requires input in the cells A2:H2, On Page 2 I have a table of values. A2:H2-A250:H250 contains all the data values that i need to enter into my formula.
I then need to place the value of Sheet 1 A2,B2,G2 and the resulting value from the formula into sheet 3 For all of the 250 values in Sheet 3.

Is there a way for excel to do this process without having to go through all those values manually, which is what i am currently doing , This will save me many hours a week if there is.

thanks

. g b z .

 

[BennyD]

i'm not quite sure what you mean but have you tried using "$" before you grid references?

 

[Yossarian]

1. wrong forum.

2. why don't you copy the formula down through row 250? Excel will automatically modify the cells that the formula looks at for input.