copying/dragging a formula to adjacent cells in Excel

[Guest]

Hi,
Thanks for any help. I have a list of data in column A in worksheet 1. I
want to show that data in row 1 of worksheet 2. So, I've got data shown
vertically that I want to show horizontally in a different worksheet. When
I drag from my 1st Formula cell horizontally, the cells pull data from the
associated row in the formula. The same if I drag downward - the data is
pulled from the associated column.

Is there a way to override this default so excel with populate my row 1 in
worksheet 2 with worksheet 1's column A of data?

 

[Gord Dibben]

Steve

In A1 of sheet2 enter this formula.

=INDIRECT("Sheet1!A"&COLUMN(A1))

Drag/copy across row 1.

Going the other way.............

=INDEX(Sheet1!$1:$1,ROWS(Sheet1!$1:1))

Drag/copy down any column.


Gord Dibben MS Excel MVP


On Tue, 17 Apr 2007 09:22:00 -0700, Steve Brennan <Steve