VBA Macro Save Everything from a Dropdown list to a new folder in my documents folder

Hi!

I have a dropdown list in a specific cell in one of my sheets. It contains all of the names that I need.

On the same worksheet, it must be saved as the infos are changing when choosing a new name from the dropdown.

The task is - in just one macro button, I must save the file from every dropdown list in my documents folder (a new one) in an excel file still but the cells would have no formulas at all. What should be done? Is there a code that could do this?

Thank you so much!

The sheet "SHSF-9 (F138) (2)" is the sheet that I want to save for each name. Upon choosing male in sex, the list of the boys will be seen on the dropdown of the names. Same goes when you choose the female as sex- names of girls will be reflected on the dropdown. Since it is a grading card, I am looking for a way to save all of the names on the dropdown list in just a click of macro, if possible.

Thank you so much!

Thanks for the suggestions. How about, save to PRF? Thank you so much!

yes, pdf. sorry for the typo. thank you so much

Noted Sir, thank you so much!

Thank you so much! Your method clarifies it all. Thank you so much!

Hi Sir! Just another query. The saving of sheets is triggered whenever I shift from male to female or vice versa. Is there another way to move it, the saving to another button instead of male to female dropdown? Thank you so much!

Many thanks for your quick responses sir! God bless!