I have a worksheet with a drop down list in "B2" to filter the data and I have a code to save the viewed information in the sheet as PDF to external forlder "D:\Desktop\Daily Tasks" and to name the file based on cell value in "C2"
My drop down list has only 5 items (NH01,NH03,NH04,NH05,NH06)...