Hi,
I was wondering if there was a way to have excel look into a folder and identify all the excel files in that folder. i.e. a vaildation drop-down that shows every file in the folder so I can choose which one to add.
I have a hundred or so files in a folder and am constantly adding new ones.
Any thoughts?
Thank you
I was wondering if there was a way to have excel look into a folder and identify all the excel files in that folder. i.e. a vaildation drop-down that shows every file in the folder so I can choose which one to add.
I have a hundred or so files in a folder and am constantly adding new ones.
Any thoughts?
Thank you