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
 

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

--

Regards,
Nigel




"twinmommie" wrote in message
...
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 subsequ
 

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!

Changes made in first tab-automatically update through subsequ
 

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


On Nov 6, 12:25*pm, twinmommie
wrote:
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!

Changes made in first tab-automatically update through subsequ
 

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

"Susan" wrote:

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


On Nov 6, 12:25 pm, twinmommie
wrote:
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!

Changes made in first tab-automatically update through subsequ
 

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


On Nov 6, 12:40*pm, twinmommie
wrote:
I did not create the database, am I going to have to start from scratch to
match all the formulas?



"Susan" wrote:
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

On Nov 6, 12:25 pm, twinmommie
wrote:
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!- Hide quoted text -

- Show quoted text -

Changes made in first tab-automatically update through subsequ
 

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" wrote:

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


On Nov 6, 12:40 pm, twinmommie
wrote:
I did not create the database, am I going to have to start from scratch to
match all the formulas?



"Susan" wrote:
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

On Nov 6, 12:25 pm, twinmommie
wrote:
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!- Hide quoted text -

- Show quoted text -

Changes made in first tab-automatically update through subsequ
 

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

=A!A1

susan


On Nov 6, 4:53*pm, twinmommie
wrote:
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" wrote:
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

On Nov 6, 12:40 pm, twinmommie
wrote:
I did not create the database, am I going to have to start from scratch to
match all the formulas?

"Susan" wrote:
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

On Nov 6, 12:25 pm, twinmommie
wrote:
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!- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Changes made in first tab-automatically update through subsequ
 

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!

"Susan" wrote:

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

=A!A1

susan


On Nov 6, 4:53 pm, twinmommie
wrote:
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" wrote:
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

On Nov 6, 12:40 pm, twinmommie
wrote:
I did not create the database, am I going to have to start from scratch to
match all the formulas?

"Susan" wrote:
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

On Nov 6, 12:25 pm, twinmommie
wrote:
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!- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -