Hello,
I have a folder located in the ActiveWorkbook.Path, called “Sales”
The “Sales” folder might contain various subfolders, for example:
East Teritory
West Teritory
North Teritory
South Teritory
but could be anything else….
I need to “Data Validate” a cell which would pull up at the Data Validation Drop Down the subfolders names and when a subfolder is selected from the Drop Down, I want that cell to be hyperlinked to the subfolder.
(see screenshots)
Please advice.Screenshots.JPG
Thanks