SimmonsDeux
New Member
- Joined
- Dec 29, 2014
- Messages
- 17
Hello!
I've a unique (perhaps overly complicated) task I'd like to achieve. I have a list of files in this directory:
T:\QAP Coaching\
That are named all sorts of randomly generated numbers and letters. They all have names in Cell B2, though.
Now, in a separate excel file I have a data validation list (in cell A3) of all of the possible names. I would like excel to list all of the files in column F that have the name specified in the data validation cell.
Is this possible?
I've a unique (perhaps overly complicated) task I'd like to achieve. I have a list of files in this directory:
T:\QAP Coaching\
That are named all sorts of randomly generated numbers and letters. They all have names in Cell B2, though.
Now, in a separate excel file I have a data validation list (in cell A3) of all of the possible names. I would like excel to list all of the files in column F that have the name specified in the data validation cell.
Is this possible?