abssorb
New Member
- Joined
- Apr 15, 2008
- Messages
- 34
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
We have project status reports in excel format, which are highly stylised and not in a table, and they are gathered into a sharepoint 2010 folder once a month.
There's a team who soulfully open each file and then manually cut and paste data into a master portfolio spreadsheet, and their time can be better spend on finer work.
I want to be able to use macros / something which pulls in the latest data each month from all of the supplied reports.
The reports will all use the same template, but they might be received each month in a different quantity and will probably have a different filename to last month (for the same project).
Corporate environment, zero opportunity to install extra server software or desktop apps / excel plugins.
I'd be really grateful for tips on approach / strategy for this, or links to any reading material. Or perhaps this has been asked before (I did try searching but couldn't find anything suitable).
Thanks
There's a team who soulfully open each file and then manually cut and paste data into a master portfolio spreadsheet, and their time can be better spend on finer work.
I want to be able to use macros / something which pulls in the latest data each month from all of the supplied reports.
The reports will all use the same template, but they might be received each month in a different quantity and will probably have a different filename to last month (for the same project).
Corporate environment, zero opportunity to install extra server software or desktop apps / excel plugins.
I'd be really grateful for tips on approach / strategy for this, or links to any reading material. Or perhaps this has been asked before (I did try searching but couldn't find anything suitable).
Thanks