You can't do it that way. OK dragging down a column but not across a row

Enter in B1

=INDIRECT("'worksheet name'!A" & COLUMN())

Drag/copy across.


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 19:08:41 -0400, tpsstudent
wrote:


Is it possible to drag the cell with a formula in it so that it can be
repeated with a pattern changing?

Might sound confusing, what I mean is can i put
'worksheet name'!A2 and then 'worksheet name'!A3 to the right of it and
then select both and drag to the right so that the number goes up while
the letter stays the same.

I've tried using $ to make it absolute but excel just keeps repeating
the same two squares without changing the number.