Hi All - I've been searching a long time and can't solve this one.
My Workbook has a Worksheet named "Summary" with a list of various country names in Column A starting at A11. It is a dynamic list, so the countries in this list can change.
My Workbook also has Worksheets for most of the countries. They are named by the country name. There are some countries that appear in the Summary that I do not have a Worksheet for.
I'm trying to create a macro that will save the "Summary" worksheet and all the Country worksheets toa single PDF. If I do not have a worksheet for country, I just want to skip it.
Thanks for any help. I've learned a lot from browsing but this one is proving too advanced for me!
My Workbook has a Worksheet named "Summary" with a list of various country names in Column A starting at A11. It is a dynamic list, so the countries in this list can change.
My Workbook also has Worksheets for most of the countries. They are named by the country name. There are some countries that appear in the Summary that I do not have a Worksheet for.
I'm trying to create a macro that will save the "Summary" worksheet and all the Country worksheets toa single PDF. If I do not have a worksheet for country, I just want to skip it.
Thanks for any help. I've learned a lot from browsing but this one is proving too advanced for me!