Row to Columns

[Mjoza]

How can I make a formula or macro to bring numbers in a column to be in a row?
For example I have data in cell range A1:A5 in tab 1 and I want that data to be displayed in tab 2 in range A1:E1. If its a formula I want to be able to go to tab 2 in cell A1 and drag it over to E1 and have the range in tab 1 column A displayed.

I'm using excel 2007

Thanks!

Mjoza

 

[Jonmo1]

Welcome to the board...

Try this in Tab 2 A1 and filled right to E1

=INDEX('Tab 1'!$A:$A,COLUMNS($A1:A1))

Don't change the $A1:A1, it has nothing to do with the location of your data

Hope that helps.

 

[Mjoza]

That works, thank you so much.