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!