| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update one worksheet tab to automatically update all other tabs?
I have a spreadsheet that has SEVERAL tabs of information... I want to be
able to edit/add/delete to first "master" tab and have it update information across all the other tabs.... the other tabs are not in the same order as the master.... please help!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update one worksheet tab to automatically update all other tabs?
Use linking formulas. For example, to get data from the "Master" tab cell
B9, use: =Master!B9 -- Gary''s Student - gsnu200854 "shoechic1" wrote: I have a spreadsheet that has SEVERAL tabs of information... I want to be able to edit/add/delete to first "master" tab and have it update information across all the other tabs.... the other tabs are not in the same order as the master.... please help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Worksheet Name Base on Cell Input Automatically? | Excel Discussion (Misc queries) | |||
| How do I automatically update my accountability worksheet from my | Excel Worksheet Functions | |||
| Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
| Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
| Can I update a worksheet automatically while it's open elswhere? | Excel Discussion (Misc queries) | |||
Linear Mode
