Hello,
I have been working on a usage report to be provided to multiple clients for quite some time. This site has been very helpful along the way but I need to add to my current macro.
Currently I have a button that executes the following macro:Currently this macro refreshes a direct data connect from SQL server, does AutoFit/Sorting of columns in in the "Output" tab, and automatically formats the print area of my report to be sent to clients.HTML Code:
Information to be sent to clients is on the "Template" tab which is a direct pull from the "Output" tab using Index Match formulas.
However, this is dependent on selecting a client from a data validation drop down list prior to executing the macro. What I'm looking for is the ability to cycle through all of the clients and pull the usage information with just one click of the button.
The drop down list currently resides in cell C5 from the "Output" tab. In addition, I need just the worksheet "Template" for each client saved in a folder with the name of the client and date in the report name.
I appreciate any feedback and thank you for your time.
Bookmarks