July 11, 2020
My problem is I have a worksheet with a dropdown menu. The content that is displayed in the property 1,2 &3 worksheets depends upon what is my number selected as in E1 Cell. I want to write a code such that it takes all the numbers that are mentioned in drop-down and make a combined PDF with name same as E1 Cell with data in all the worksheets displayed on separate pages. This process should be done individually for all the numbers that are mentioned in the dropdown.
I have uploaded two files one an excel and one pdf. The pdf is what I want as the desired output. This is just for number 1. Similarly, I want for number 2.
December 20, 2019
By its nature the drop down can only have one number in it, so i assume you mean that you want a 3 page PDF for each row in the master sheet?
Try this - you will need to change the saving location and the file name as i am just calling them row 1 and row 2 etc