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!

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!

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!