Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Tabs
Hi Ill try explain as best I can - If I have all the information I need on
the first tab in my work book and I then need to split this information and copy it into another 2 seperate tabs. If i then change any data written or numbers on the first tab how can i make the inaformation automatically change in the other 2 tabs so all info is eaxactly the same even thought its been split up? I have tried paste special and it does not seem to like this Any help greatly appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Tabs
When you first copy the data and then navigate to the new sheet, instead of
simply pasting the data, right click in the new location and choose "Paste Special", and then click on "Paste Link". This creates a link between the 2 sheets, where any change to the original will be reflected in the new sheet. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "sut3030" wrote in message ... Hi Ill try explain as best I can - If I have all the information I need on the first tab in my work book and I then need to split this information and copy it into another 2 seperate tabs. If i then change any data written or numbers on the first tab how can i make the inaformation automatically change in the other 2 tabs so all info is eaxactly the same even thought its been split up? I have tried paste special and it does not seem to like this Any help greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should let me format worksheet tabs in multiple rows. | Excel Worksheet Functions | |||
Sheet Tabs | Excel Discussion (Misc queries) | |||
Tabs accross of bottom of sheet are not showing | Excel Discussion (Misc queries) | |||
Hidding Tabs | Excel Discussion (Misc queries) | |||
Sheet tabs disappear sometimes in Internet Explorer | Excel Discussion (Misc queries) |