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

C

CAPTGNVR

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.
 
D

driller

Hi CAPT
in cell A1: =sheet1!$G$4
Click to expand...
try =sheet1!$G4

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

--
regards,
driller

*****
- dive with Jonathan Seagull
 
C

CAPTGNVR

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
 
D

driller

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

i hope also<bg>
--
regards,
driller

*****
- dive with Jonathan Seagull
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open four Wbooks, copy four columns from each to Master Wbook 16
simple code but it doesn't look like usual vba code 2
Arrays and scattered cell values or another way? 16
Macro autofills formula when a cell value is changed 4
Copy range from one sheet to another cell by cell 3
Modify working code to expand the output. 5
copy formula across while skipping columns 2
copy across formula while skipping columns 1

Top