Changes made in first tab-automatically update through subsequent

[twinmommie]

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!

 

[Nigel]

You can of course add formula in other tabs to the master data

In a cell put =Master!A1

Which places the value on the master sheet into that cell, change A1 on the
master and it changes elsewhere

 

[twinmommie]

I have 80 lines that need to update into other tabs. Do I add this formula
into each tab and it updates?

Thanks for your help!

 

[Susan]

you'll have to take the time to set it up, initially, but after that
it will update itself.

so in tab C you might need (in the right places)
=Master!A1
=Master!B12
=Master!D5

and in tab D you might need
=Master!F15
=Master!G15
=Master!A6

etc.
it takes time & effort to set it up right, but you only have to do it
once.

susan

 

[twinmommie]

I did not create the database, am I going to have to start from scratch to
match all the formulas?

 

[Susan]

you don't have to touch tab A. but tabs 2-10, yes, you're going to
have to enter the formulas where you want them - the first time.

say tab A, range A1 is somebody's name.
on tab 2, range B1 you want that information. you enter =A!A1
on tab 5, range D5 you want that same information. you enter =A!A1
on tab 7, range B12 you want that same information. you enter =A!
A1

now tab A, range C1 is somebody's address.
on tab 2, range B2 you want that information. you enter =A!C1
on tab 5, range D8 you want that same information. you enter =A!C1
on tab 10, range E15 you want that same information. you enter =A!
C1

and so forth.

now everytime tab A range A1 changes, those other ranges will
automatically update. and everytime tab A range C1 changes, those
other ranges will automatically update. like i said, it takes time
and effort to set it up, but once you've got it all set up it handles
changes automatically.
as far as i know there isn't any other way to do it, aside to write a
macro but nobody could do that for you without a copy of your
workbook, because they wouldn't know what ranges went where.
hope that helps explain it.
susan

 

[twinmommie]

Thanks, it helps a lot.

Is the formula I use for Tab A just "A1" or do I need to enter any other
characters?

Thanks!

 

[Susan]

to refer to sheet A, range A1, you'd have to enter

=A!A1

susan

 

[twinmommie]

Hi!

I've been completely rewriting the worksheet with your help!

The info from tab A has been put into place using the formulas. I've run
into a snag though- I have the formulas in place. But when I update tab A-
it does not update tabs 2 - 10.

What am I doing wrong? Thanks!