Hi CAPT
in cell A1: =sheet1!$G$4
try =sheet1!$G4

copy A1:C1 down to row 50, but do this in a test sheet!<g

--
regards,
driller

*****
- dive with Jonathan Seagull



"CAPTGNVR" wrote:

DEAR ALL
For ex:

in cell A1: =sheet1!$G$4
in cell B1: = M20 * N20
in cell C1: = Q20 * SHEET1!$F$2

Is it possible to copy the range a1.c1 till row 50 using fill down and the
result should be like this.

in cell A2 : =sheet1!$G$5 (THIS ABSOLUTE SHOULD CHANGE FROM $G$4 TO $G$5
AND SO ON.

in cell B2 : = M21 * N21

in cell C2: = Q21 * SHEET1!$F$2 (THIS ABSOLUTE SHOULD NOT CHANGE)

I am using excel 97. Pls help.