Hi,

this may seem a bit crazy but it may help:

Make your reference to sheet 1 like this:

Insted of Sheet1!A1, B1, C1
make it Sheet1!$A1, $B1, $C1

This stops Excel changing the cell references when you copy to the
right.

Enter your first 3 formulae (A1:A3).

Then highlight those 3 cells and copy them to B2. This will change the
references to the rows but not the references to columns. Then
highlicht those cells in B2:B4 and MOVE them to A4. This will NOT
change any cell references.

Highlight all you've got in column A so far and copy to column B into
the row number that you want the A1 reference to become. Move what
you've then got in column B below the last entry in column A.

Repeat this until you're done.

Hope this helps a little bit.

Hans