linking worksheets in same workbook

[Guest]

How do I link worksheets and transpose data simultaneously?

 

[Richard Neville]

Let's say you want the data in sheet X also to appear in sheet Y. First,
enter the data in X. Then, in Y, click on a cell, let's say B2. Type =,
switch to sheet X, and click on B2. Now, whenever you change the value in B2
of sheet X, the change will also appear in B2 of sheet Y.

You can spread this formula across and/or down within sheet Y until all the
values of sheet X are covered. Copy and paste headings as needed.