"Auto-create" 40 Different Versions of a Sheet

[anticore]

This is my dilema,

I have a report I built on excel that is populated with data from an access database. The report pulls monthly stats per "sales group" I made one cell into a validated list that once I change it to another sales group, the entire sheet is updated with the values of the new selected group....

I have 40 or so groups, If I wanted to quickly print or view all 40 reports, how do i do that?

[anticore]

what if i create a sub

Sub createReport()

create a new book,
copy the report sheet into the new book
and make a loop, changing the value of the field that determins what "sales group" is listed

would that work?
if so, can someone provide some guidence

[Paul]

http://www.mrexcel.com/forum/showthread.php?t=412803

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!