| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changes made in first tab-automatically update through subsequent
I have a spreadsheet with 11 tabs. The first tab (tab A) contains all the
info. The subsequent tabs are info (tabs 2 - 10) containing parts (sections) of the first tab. Can I set up excel so that when I update the info in Tab A, the info will automatically update in Tabs 2 - 10 without me having to go into each tab individually and change the info. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changes made in first tab-automatically update through subsequent
If sheet A has all the info, can you use formulas on the following sheets
that reference sheet A? Then they would update like your wanting? Depending on what type of info you have, you could try using LOOKUP functions, or VLOOKUP. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "twinmommie" wrote: I have a spreadsheet with 11 tabs. The first tab (tab A) contains all the info. The subsequent tabs are info (tabs 2 - 10) containing parts (sections) of the first tab. Can I set up excel so that when I update the info in Tab A, the info will automatically update in Tabs 2 - 10 without me having to go into each tab individually and change the info. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changes made in first tab-automatically update through subsequent
See help on linking between worksheets.
Gord Dibben MS Excel MVP On Thu, 6 Nov 2008 08:13:01 -0800, twinmommie wrote: I have a spreadsheet with 11 tabs. The first tab (tab A) contains all the info. The subsequent tabs are info (tabs 2 - 10) containing parts (sections) of the first tab. Can I set up excel so that when I update the info in Tab A, the info will automatically update in Tabs 2 - 10 without me having to go into each tab individually and change the info. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto update of date and time whenever changes are made to a xcel s | Excel Worksheet Functions | |||
| auto update of date and time whenever changes are made to a xcel s | Excel Worksheet Functions | |||
| Not all Filters made on Page Field Variables Update the Data | Excel Worksheet Functions | |||
| How to prevent file date change when no update made in Excel? | Excel Discussion (Misc queries) | |||
| If one cell given value others in row be made blank automatically? | Excel Worksheet Functions | |||
Linear Mode
