VB code to copy a row with absolute cell ref and also relative cel
 

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.

VB code to copy a row with absolute cell ref and also relative cel
 

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.

VB code to copy a row with absolute cell ref and also relative
 

D/Driler

WOW. So simple is it. Thanks. I didt realise that i could use it like
$G4. Well the quickest reply I ever got and can consider this thread closed.
brgds/captgnvr

"driller" wrote:

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.

VB code to copy a row with absolute cell ref and also relative
 

nice to hear your thread as in "close"...

i hope also
for my thread as well.
<bg
--
regards,
driller

*****
- dive with Jonathan Seagull



"CAPTGNVR" wrote:

D/Driler

WOW. So simple is it. Thanks. I didt realise that i could use it like
$G4. Well the quickest reply I ever got and can consider this thread closed.
brgds/captgnvr

"driller" wrote:

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.