Updating indivudal sheets thru a Master sheet

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a Master sheet with sales data - for example Salesman Name, Customer
Name, 2007 total and monthly 2008 totals. I then have individual sheets for
each Salesman with customer Name, 2007 total and monthly 2008 totals. What I
would like to do is each month dump the data in the master spreadsheet and
have the inidividual sheets automatically updated. How can I link the
subsheets to the master sheet?

Thanks.
 
Thanks....I don think a pivot table would do in this instance,since I have
other data(formulas) in the individual sheets. I need to link the cell
somehow but am not sure how to do that.
 
Back
Top