Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |