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!!!!