Creating Report from Multiple Workbooks
Hello, I'm fairly new to excel and vba, just after some advise please!
I have two spreadsheets associated with each of my projects, one called projectcosts.xls and one called projectspends.xls. These are stored in the same folder and are identical for each project. There are currently over a hundred projects and this will continue to rise, so we have quite a few of these files. The project costs sheet details all the costs we have allowed on each project. The project spends detail all the money we have spent on each project. They work really well on their own.
I would like to be able to create some custom reports to pull information from each sheet or several sheets such as:
1. Displaying all labour spends for all projects
2. Displaying order spends for a single project
3. Displaying project overview (all costs in and spends out) for all projects and a single project.
The question is, how would you do it!?..Whats the best route.
I've tried creating more worksheets and importing/linking data but found it to be a bit messy and time consuming. I've also tried importing the data into an Access database and creating webpages via ASP code. This is a bit more successful but is also taking a lot of my time to get right. Are there any reporting suites out there?
I'm quite tempted to scrap excel and write straight to a database, but the data entry girls like excel, I only know some basic ASP, and I don't really want to implement an entire new system...
I'll stop waffling now!...Thanks in advance. :)