I have over 4000 files for customer equipment. Those files contain pictures and closed work orders for the equipment. I have set up a master sheet and pulled specific information about the customers equipment but need to have a quick way for others to go directly to the folder. Is there a way that I can create a search shortcut for a specific folder located on my x: drive based on the information that is entered into the master sheet in cell B2?
Any input is appreciated.
Bookmarks