Hello,
I have an excel document where I need to create a hyperlink to the direct file in file explorer - while I understand how to do this manually, when there are 10+ file this become extremely tedious.
I would like Column B to be the hyperlink (while maintaining the file names that are already in this report I exported from our ERP) so that end users may click on the filename and popup the associated file. The file location of said files is G:\Customer Orders\22H01-\Customer\Drawings\IFC Drawings and this is a static location.
I am attaching the spreadsheet I am using with my attempted hyperlink formula that does not work at all.
WOR-TRN-009735 - Transmittal List - 8.1.2022.xlsxWOR-TRN-009735 - Transmittal List - 8.1.2022.xlsx
Bookmarks