Hi guys,
I have a dashboard type page developed that I have to print multiple pages from based on the customers I'm filtering. On my main document, the overall filtering of the customers can be large so it would be a pain to sit and try and print each individual one. What I want to do is create a macro that goes through and takes each customer individually from the first to the last on the Data sheet, goes to Dashboard sheet and prints each individuals customers information based off of the filtered data from the Data sheet.
So for example, I have it filtered on location looking at North customers only. My macro currently just goes back and forth and clicks on the next one printing in between. I've obviously realized this is not a good way to do it as if you filter to east there are only two customers so it will print a blank third blank page. So, all in all I'm looking for it to realize how many rows actually have data, take only that amount one by one and print each one from the Dashboard sheet.
Any help would be greatly appreciated.
Bookmarks