View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Updating indivudal sheets thru a Master sheet

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.
--
Bob