Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated spreadsheet Consolidation
I receive about 50 spreadsheets a week for a survey. I need to consolidate
the information into one spreadsheet. How can I crete a macro/formula/vba script which will automate this process so that I don't have to open the 50 spreadsheets? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated spreadsheet Consolidation
If you just mean append the information down a single sheet, then just
search google groups for consolidate http://groups.google.co.uk/groups?as...ng&lr=&hl=e n the URL should all be on one line -- Regards, Tom Ogilvy "Rob" wrote in message ... I receive about 50 spreadsheets a week for a survey. I need to consolidate the information into one spreadsheet. How can I crete a macro/formula/vba script which will automate this process so that I don't have to open the 50 spreadsheets? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking Cells in an Automated SpreadSheet | Excel Discussion (Misc queries) | |||
Consolidation | Excel Discussion (Misc queries) | |||
Consolidation | Excel Discussion (Misc queries) | |||
Automated userform inputs to the spreadsheet | Excel Programming | |||
Automated userform inputs to the spreadsheet | Excel Programming |