How to select and print all options under two dropdown lists into a single PDF file

I have very limited coding/macro knowledge so appreciate for any help....

Here is my question;

I have an excel file with multiple tabs and one tab called "Discipline details" has two dropdown menus located in cell B3 and B4.

B3 has two options (lets say A,B) and B4 has 26 options (lets say 1,2,3,4....26). I would like to write a macro to automatically select and print A-1, A-2,A-3,....A-26, B-1,B-2,....B-26 into one combined pdf file.

I did some re-search and found some code pieces. They can do part of what I need but I could not combine them to solve the problem (print all selections from b-3, b-4 into one single pdf file.)

1 - With below I can print an active sheet into a PDF

Please Login or Register  to view this content.

2 - With below I can print all options under B4 but I would like have two selections. I.e; a loop that select the main category first from B3 and print 26 sub categories from B4 and then select second main category from B3 and print 26 sub categories from B4. Also with below code I can print only to separate pdfs and at each print I need to manually define a file name.

Please Login or Register  to view this content.

Appreciate for any help...

Thanks M.