Shouldn't A10, be A11?

You could use a formula like:
=INDEX(Sheet1!A:A,(ROW()-1)*5+1)

Or you could use this technique:
Put this in A1:
$$$$$sheet1!a1
Put this in A2:
$$$$$sheet1!a6

Select A1:A2 and drag down as far as you need it.

Select that range
edit|replace
what: $$$$$
with: =
replace all


Volume wrote:

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

--

Dave Peterson