Good afternoon,
So I frequently have to search for files investigating things. I have made this a little easier with formulas where I can just paste a list of the order numbers in column A on a spreadsheet and hyperlinks to the folders are generated in column B. So many times I create a folder to put my findings in, and I was wondering if I can make a code to create a shortcut in a folder for each file path in my list?
All the formula is performed on Sheet 2 with column G value equals the file path. I would like a button on Sheet 1 to perform this function and create the shortcuts either in the file path of the work book or open file dialog to select folder.
So I frequently have to search for files investigating things. I have made this a little easier with formulas where I can just paste a list of the order numbers in column A on a spreadsheet and hyperlinks to the folders are generated in column B. So many times I create a folder to put my findings in, and I was wondering if I can make a code to create a shortcut in a folder for each file path in my list?
All the formula is performed on Sheet 2 with column G value equals the file path. I would like a button on Sheet 1 to perform this function and create the shortcuts either in the file path of the work book or open file dialog to select folder.