Hopeful End:
Project will cycle through Named Range and save as “provider name and today’s date”.pdf in a created folder named, today's date. The saved file will include up to 4 worksheets and their pages.
The 4 worksheets to be “saved as pdf” are colored red. The data being gathered is the same as found in the data worksheets but provider name column is excluded. (The provider name is in Cell A1 of each final sheet and pulls from the named range.)
Named range is called Provider_Names and is found on the purple worksheet (Provider Names) in B1
File name is found on the purple worksheet at D2
There are three data worksheets that have one common element – Provider – always in Column A. Not all sheets have the same providers so if the provider is not relevant to the corresponding red worksheet then I’d would like it not to save as with other Worksheets (If easier – if blank then enter “Compliant”).
If you can think of a better way to accomplish this task – I’m listening. Or, if you can point me in the right direction, I’d appreciate it.
Bookmarks