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!

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
(E-Mail Removed)



"twinmommie" <(E-Mail Removed)> wrote in message
news:1AF26B14-460E-4908-9FA4-(E-Mail Removed)...
>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!

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!

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 <twinmom...@discussions.microsoft.com>
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!

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 <twinmom...@discussions.microsoft.com>
> 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!
>
>

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 <twinmom...@discussions.microsoft.com>
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 <twinmom...@discussions.microsoft.com>
> > wrote:
> > > I have 80 lines that need to update into other tabs. *Do I add thisformula
> > > into each tab and it updates?
>
> > > Thanks for your help!- Hide quoted text -
>
> - Show quoted text -

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 <twinmom...@discussions.microsoft.com>
> 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 <twinmom...@discussions.microsoft.com>
> > > 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 -
>
>

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

=A!A1

susan


On Nov 6, 4:53*pm, twinmommie <twinmom...@discussions.microsoft.com>
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 <twinmom...@discussions.microsoft.com>
> > 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 <twinmom...@discussions.microsoft.com>
> > > > 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 -

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 <twinmom...@discussions.microsoft.com>
> 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 <twinmom...@discussions.microsoft.com>
> > > 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 <twinmom...@discussions.microsoft.com>
> > > > > 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 -
>
>