Linking Data from 2 worksheets without transposing

[ahc0037]

Hi, I am having issues with excel 2010. I am trying to link data from worksheet 1 to worksheet 2. Worksheet one has data entered horizontally and worksheet 2 needs to be entered vertically. I do not want to use the transpose function because it will not reference each individual cell in worksheet 2 to worksheet 1.

Can you please advise a solution?

Thanks

[Lemice]

Hello and welcome to the forum,

One way that comes to my mind when I read your post is that you can use INDIRECT function in combination with ADDRESS, ROW and COLUMN, for example, paste this formula in B1 and drag it down
=ADDRESS(COLUMN()-1,ROW(),4)

And you will see a series of A1, B1, C1, ... If you put them in the INDIRECT, you will get the results you want.