| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link multiple tabs in new worksheet
Ive got 2 xls file each with 7 tabs in them lets call them books A.xls and
B.xls. I want to take all the information from the 7 tabs in book A.xls and place it in a new book called ZZZ.xls. So I have all the information from book A placed in 1 sheet on ZZZ.xls. I know I can simply copy and paste this information on tab at a time but the trick is I want anything that I update in book A.xls to be reflected in my new file ZZZ.xls. So if I add a line in the 3rd tab in book A I want it to show up in the appropriate place on my new ZZZ.xls file. So how do I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling info from multiple worksheet tabs? | Excel Discussion (Misc queries) | |||
| Display multiple tabs in current worksheet | Excel Worksheet Functions | |||
| Worksheet tabs on multiple lines? | Excel Worksheet Functions | |||
| Excel should let me format worksheet tabs in multiple rows. | Excel Worksheet Functions | |||
| How can I create multiple rows of worksheet tabs in a workbook? | Excel Discussion (Misc queries) | |||
Threaded Mode
