I'll greatly appreciate it if anyone can help me with this:
I'm looking to create a macro that will print to PDF from drop down lists and save with discernible file names.
There are two worksheets within a workbook that has drop down menus: Cpk and Ppk. The drop down menu is a button. A related cell (not sure how it's related) is Cpk cell: R1 and Ppk cell: T2.
A page per drop-down item needs to be printed to pdf for both worksheets Cpk and Ppk. Worksheets within the same workbook will have the same number of item numbers. A different workbook may have only 3 items.
Specifically I'd like it to:
1) Go to Cpk worksheet
2) select from the drop down menu (eg Item 1-9)
3) select one of the options from the radio buttons [One sided (Max), One sided(Min) or Two sided spec(bilateral)] --> (eg. One sided (Max))
4) print from the Cpk worksheet drop down menu to PDF, save it as "Name of the file-Name of the Worksheet-Name of the Spec Value (Cell:A6)-Date (Cell:O4) (eg. 工程能力調查表-Cpk-寬度2-1090206)
5) select the next item in the drop down menu
6) select one of the options from the radio buttons [One sided (Max), One sided(Min) or Two sided spec(bilateral)] --> (eg. Two sided spec(bilateral))
7) print to pdf (for example 工程能力調查表-Cpk-寬度3-1090206)
8) select the next item until it reaches the last item (# of items could vary from one workbook to another)
9) Go to Ppk worksheet and perform steps 2-8
The print range on both worksheet is already set to print one 1 page. All fonts in GREY are outside of print area.
Please Note: This workbook was not designed by me and I am open to changing the core design of it as long as I can produce the same outcome. I can see the radio button causing unnecessary complexity to the macro. Can the radio buttons be automatically populated the moment an item # is selected from the drop down menu?
Thank you in advance!
Bookmarks