View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tommy Tommy is offline
external usenet poster
 
Posts: 70
Default Master Spreadhseet retrieves data from children automatically

Hallo,

I currently have 10 children spreadsheets that update their data every
afternoon. I want to create a masterspreadsheet that retrieves CERTAIN
COLUMNS of each children spreadsheet. If the data of the children spreadsheet
changes, I obviously would like that change to be also updated automatically
in my master spreadsheet. How do I implement that most elegantly?