How to Create Multiple HyperLinks in Excel Spreadsheet all-at-once
I know how to create hyper-links in Excel, on an individual basis. Is there a way to hyper-link a large list of items in one-shot?
For audit purposes, I was asked to create a spreadsheet with a list of 300+ file names in sequential order (e.g. 057309206.TIF, 057309207.TIF, 057309208.TIF, etc.). I would like to have the file name referenced in each cell hyper-linked to the corresponding file located in a specific folder.
Is there a way to do this with existing Excel functions, or VB Code?
Visual Basic ClassicMicrosoft ExcelVB Script
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!