Hi all
Ive created a project report template that will go out to 15 consultants. Id like to be able to collate a work sheet called "Summary" from each of these reports into a new workbook.
My idea is to place all of the workbook into a folder, and then place into the folder my summary workbook - which when open alloows you to click a button that will run a macro that will extract from each of the workbooks in that folder the worksheet entitled "Summary".
Is this possible? any ideas?
Thanks for you help
Tim
Ive created a project report template that will go out to 15 consultants. Id like to be able to collate a work sheet called "Summary" from each of these reports into a new workbook.
My idea is to place all of the workbook into a folder, and then place into the folder my summary workbook - which when open alloows you to click a button that will run a macro that will extract from each of the workbooks in that folder the worksheet entitled "Summary".
Is this possible? any ideas?
Thanks for you help
Tim