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
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