Home |
Search |
Today's Posts |
#1
|
|||
|
|||
linking worksheets in same workbook
How do I link worksheets and transpose data simultaneously?
|
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking cell value in one workbook to a cell in another workbook | Links and Linking in Excel | |||
sotring worksheets in a workbook | Charts and Charting in Excel | |||
Removing links to other worksheets from within a workbook | Excel Discussion (Misc queries) | |||
Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel | |||
One header for all worksheets in workbook | Excel Discussion (Misc queries) |