Hi,
Every time I search for a solution on the web I keep finding the “Tech Republic” so I decided to come straight to the source.
The problem I have is this:
I have one database with a macro set to produce 60+ tables based on a single criterion which changes from 1 to about 15. The Access output is generated in a ‘feed’ worksheet in Excel (via a Data Link) with one worksheet for each table. Data is extracted from each Excel worksheet in the feed worksheet to produce a one page ‘report’ worksheet in Excel. At the moment I am running the Access macro, refreshing the data in the feed spreadsheet which changes the data in the report worksheet. Then I copy and paste the results (yes, I know!) from the report spreadsheet to a new spreadsheet to provide a permanent record for a single value of the criteria.
What I would like is to be able to generate one separate report worksheet for every value of the criteria without manually re-running the Access macro etc.
Any and all help would be appreciated.
Regards,
Stewartie