View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
twinmommie twinmommie is offline
external usenet poster
 
Posts: 6
Default 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!