quick excel question

Posted By Message

MarathonKnitter
HAPPY

Member since 2/07

17374 total posts

Name:
EMBRACING CHANGE

quick excel question

i'm creating a database. each week has a spreadsheet, then i'll be merging them all in a master spreadsheet... so far so good.

my question is, how so i make sure that if i make a change in the weekly OR the master spreadsheet, that the change will be reflected in the other?

is it automatic or do i have to establish that?

tia

Posted 11/21/10 8:27 AM
 
Long Island Weddings
Long Island's Largest Bridal Resource

queensgal
Smile

Member since 4/09

3287 total posts

Name:

Re: quick excel question

You have to link the spreadsheets by using formulas.

Example:

If on the master sheet you want a total cost of each week then you need to type in a sum function of each of the individual weeks. When you make a change on the week, this formula will change to reflect that

Is that what you mean?

Posted 11/21/10 9:41 AM
 

MarathonKnitter
HAPPY

Member since 2/07

17374 total posts

Name:
EMBRACING CHANGE

Re: quick excel question

sounds wonderful... let's hope i don't screw it up Chat Icon

Posted 11/21/10 10:44 AM
 

nrthshgrl
It goes fast. Pay attention.

Member since 7/05

57538 total posts

Name:

Re: quick excel question

You can also use a pivot table but would need to hit refresh to update the data.

Posted 11/21/10 2:36 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Quick Excel question MissJones 3/29/09 2 Families Helping Families ™
quick sono question..... btrflygrl 7/9/05 4 Pregnancy
Quick Question Jenn1621 6/16/05 4 Pregnancy
Starbucks quick question.......... NS1976 6/13/05 2 Families Helping Families ™
Quick Question... preciouslove 6/13/05 3 Families Helping Families ™
Quick SD question: Is Levittown SD considered good? BabyAvocado 6/9/05 5 Families Helping Families ™