I'm thinking there are 3 ways you could go with this, depending on your
flexibility:
1)Pull all relevent data from Access in to a worksheet., then create a Pivot
Table to display the data you want or use lookup/index/match functions to
calculate the specific data.
2)For each tab, create data driven Pivot Table that will pull only specific
data from Access.
3)Create a VBA solution.
Mull those over.
Post back if you need more help...There are many experts on each of those
areas avaialble on this forum.
--
Regards,
Ron
|