Macro help please!

[vmusicv]

Hi,

I inherited an Excel file with built-in macro from an ex-employee. The file
allows me to click on a drop down menu to get reports for different vendors.

I want to create a macro to print multiple sheets from the drop down menu
without having to manually click it each time to print report for each vendor
(we have 40 plus vendor so I currently have to click 40 plus time). Can
anybody help? I don’t have the ex-employee’s contact info to ask for his
help.

Thanks very much!

 

[Luke M]

Can you post the current macro?

Off the cuff, the drop down probably passes some variable (I'll says x) to
the rest of the macro. To print all 40 reports, you'll prb need to do
something like

For x = 1 to 40
'do the rest of macro
'presumably it prints the report as well
Next


And then setup either a new button or something to run this modified macro.

 

[Don Guillett]

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.