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