Hi,
I'm Trying to create a dropdown menu in excel that has the current sheets on the bottom of the document, done in a way that if sheets are added or removed they will auto populate in the dropdown. I've seen it done with PowerQuery briefly but cannot find how to accomplish this task. I've looked online and all i get is VBA scripts. Any assistance would be much appreciated.
Than You in Advance
-jlara0687
Bookmarks