Hi,

I'm making a database but having trouble with what should be a fairly simple dragging down.

In Sheet 2, I want cells A2:A120 to read (='Sheet 1'!A1).
I then want cells A121:A239 to read (='Sheet 1'!A2).
and A240:A358 to read (='Sheet 1'!A3).
and so on...

Any help?