Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to automatically change subsequent sheets after editing a master | Excel Worksheet Functions | |||
Changes made in first tab-automatically update through subsequent | Excel Discussion (Misc queries) | |||
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 | |||
If one cell given value others in row be made blank automatically? | Excel Worksheet Functions |