Hi,
i have a drop-down list (Cell C5) in Tab name Worksheet.
The drop down list contain a list of ID
is there any code that can make excel auto run through the drop down list, select each of the ID and auto save it as a new file in a specific folder (file name i have a specific name etc: worksheet_(the ID number selected in the drop down list)?
I am very very new to macro and only know how to use record.
Please help and thank you in advance!