View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
saltaway saltaway is offline
external usenet poster
 
Posts: 2
Default How to move data from spreadsheets to spreadsheet?

Hello. We have 96 spreadsheets that arrive each friday - actually six
spreadsheets from 16 locations. We need to take numbers from these sheets
and pop them into an already existing spreadsheet (this spreadsheet is setup
as an automatic numbers sheet and currently gets numbers from MS Access
(preset and batched from our other system)
The logic of it seems simple - from this cell to that cell. How do we begin
to construct a program or batch that will take the data from the weekly
sheets (same data each week) and move it into our "automatic numbers" sheet?
--
Regards and thank you for all advice!
saltaway