Max,
I notice that in sheet 2, row 1 of your example, there's this formula:
=OFFSET(INDIRECT("Sheet1!A1"),ROWS($A$1:A1)-1,)

Whereas the formula for row 2 is more complicated:
=IF(OFFSET(INDIRECT("Sheet1!A1"),ROWS($A$1:A2)-1,)=0,"",
OFFSET(INDIRECT("Sheet1!A1"),ROWS($A$1:A2)-1,))

What's the purpose of the Row 1 formula...and what if I need three or four
additional header rows instead of just one row...do I just change the "A2"s
throughout, to "A5" or "A6", etc?

Also,

"Max" wrote:

"BobW" wrote
.. where/how you inserted the formula.

In Sheet2,

Put in A2, copy down:
=IF(OFFSET(INDIRECT("Sheet1!A1"),ROWS($A$1:A2)-1,)=0,"",
OFFSET(INDIRECT("Sheet1!A1"),ROWS($A$1:A2)-1,))

From the above lines, the formula is placed in Sheet2's A2,
and then copied down

I'd select the tab: Sheet2, then select the cell A2, click inside the
formula bar, then either type-out the formula, or paste it in (if I had
copied it earlier). And then I'd press ENTER to confirm the formula. To copy
the formula in A2 down, I'd re-select A2 and point the cursor at its fill
handle, i.e. the little black solid box at the bottom right corner of A2
(the cursor will also turn into a "black cross"), and drag it down as far as
I want.

Hope the above helps ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--