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

How to move data from spreadsheets to spreadsheet?
 

Sounds more like a project instead of a question. Why not start by recording
a macro to do one and then see how to modify to do the rest. Then, remove
the selections to make it cleaner and faster

something like
lr=activesheet.cells(rows.count,"a").end(xlup).row +1
workbooks(source.xls).sheets("sourcesheet").range( "sourcerange").copy _
activesheet.cells(lr,"a")

--
Don Guillett
SalesAid Software

"saltaway" wrote in message
...
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

How to move data from spreadsheets to spreadsheet?
 

Thanks Don. Your example is beyond my current knowledge. Am quick studying
on vba to get a grasp of the example.
Appreciate your feedback. saltaway
--


"Don Guillett" wrote:

Sounds more like a project instead of a question. Why not start by recording
a macro to do one and then see how to modify to do the rest. Then, remove
the selections to make it cleaner and faster

something like
lr=activesheet.cells(rows.count,"a").end(xlup).row +1
workbooks(source.xls).sheets("sourcesheet").range( "sourcerange").copy _
activesheet.cells(lr,"a")

--
Don Guillett
SalesAid Software

"saltaway" wrote in message
...
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