View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KC8DCN
 
Posts: n/a
Default Linking and updating spreadsheets

Hi.

I have just one workbook with multiple spreadsheets. I have 1 master
spreadhseet that I want to be updated by the other spreadsheets automatically
every time I add something new to the other spreadsheets. I'm not sure of
the best possible way to do this.

Ex. If I had five item numbers to one spreadsheet and 3 items numbers to
another spreadsheet, I would like the master list to be automatically updated
in no certain order with those 8 numbers and other information.

Any ideas? Thanks!