Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make a sheet that combines all tabbed sheets & update as.
In a spreadsheet there are 4 tabs. Each tab covers a year (2000-2004). Each
tab also is identical in column names. How do I make a page that combines the contents of all tabs and will update as I update the related tabbed page? Tx! -- ahmebah |
#2
|
|||
|
|||
Check out HELP: on DATA / CONSOLIDATE
HTH Gary Brown "ahmebah" wrote in message ... In a spreadsheet there are 4 tabs. Each tab covers a year (2000-2004). Each tab also is identical in column names. How do I make a page that combines the contents of all tabs and will update as I update the related tabbed page? Tx! -- ahmebah |
#3
|
|||
|
|||
Hi ahmebah
I have a few code examples on my site to do this See http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ahmebah" wrote in message ... In a spreadsheet there are 4 tabs. Each tab covers a year (2000-2004). Each tab also is identical in column names. How do I make a page that combines the contents of all tabs and will update as I update the related tabbed page? Tx! -- ahmebah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing separate sheets on one paper sheet | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |