linking worksheets in same workbook
How do I link worksheets and transpose data simultaneously?
|
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. "pilgrimage" wrote in message ... How do I link worksheets and transpose data simultaneously? |
All times are GMT +1. The time now is 03:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com