Merged cell autofill

When you have a column of data and you want to drag down an equation, how do you keep it from skipping rows?

Ex: Cells A1-A5 are merged. Cell(A1-A5)=Sheet1!A2, and I want cell (A6-A10) to yeild Sheet1!A3. Is that possible? I hate merged cells...

Hi,

Please Login or Register  to view this content.

should do it.

HTH

I'm having trouble with this INDIRECT function, it keeps returning the invalid equation error message. Anyone have any suggestions?

Hi,

See the attached.

Rgds