Excel workbook to PDF - cycle through drop list

L

Legacy 450746

Guest
Hello!
I am completely new to Macro, so please be patient with me

I have a workbook - 10 tabs
First Tab called Parameters
Remaining 9 tabs are named by BRANDS
I have a named range in cells =PARAMETERS!$B$1:$B$8 called LIST_BRANDS
I have the path I would like the PDF's saved in cell $D$1 with named range called SAVE_PATH
I would like the PDF to save with the TAB name + Todays date

I would like the macro to do the folllowing

1. Select the first name in the List on sheet 1 "Parameters" and then calculate each of the remaining 9 sheets, then save the 9 sheets (excluding the Parameters) into a PDF document to the defined path with the defined name
2. Select the first name in the List on sheet 1 "Parameters" and then calculate each of the remaining 9 sheets, then save the 9 sheets (excluding the Parameters) into a PDF document to the defined path with the defined name

and so on....

Once the 8 PDF have been saved, display a message that says "All PDF are saved"

Is someone able to assist me please?

Thank you so much in advance
Troopy
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,095,404
Messages
5,444,265
Members
405,278
Latest member
Rashford

This Week's Hot Topics

Top