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,

=INDIRECT("Sheet1!A"&INT(ROW()/5+2))

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