Hi!

I would really apreciate some help...

I have a worksheet with some data. I have another worksheet where I
make a connection to the 1st worksheet the following way...

Field A1=Sheet1!A1
Field A2=Sheet1!A6
Field A3=Sheet1!A10
...

Now when I simply try to copy those formulas (expecting the references
to the other worksheet to increase by 5) i get nothing, that is, I get
an increment of 1 for the rest of the fields...

How do I force excel to increment by 5 when copying cells?

Thanks!!!!


--
Volume
------------------------------------------------------------------------
Volume's Profile: http://www.excelforum.com/member.php...o&userid=29693
View this thread: http://www.excelforum.com/showthread...hreadid=494090