I have a workbook with a summary worksheet and a seperate worksheet for every computer in the office.
The worksheet name is the serial number of the computer. Each computer worksheet is copied from a template so they are all the same.
I have a macro that copies certain bits of info from each worksheet and copies into columns on the summary worksheet.
One of the columns in the summary worksheet is the serial number. All the info in the summary worksheet are links to the seperate worksheet.(not values)
I would like to automatically create / convert the serial number cell to a hyperlink that opens the specific worksheet.
Any ideas?
Thanks in advance
The worksheet name is the serial number of the computer. Each computer worksheet is copied from a template so they are all the same.
I have a macro that copies certain bits of info from each worksheet and copies into columns on the summary worksheet.
One of the columns in the summary worksheet is the serial number. All the info in the summary worksheet are links to the seperate worksheet.(not values)
I would like to automatically create / convert the serial number cell to a hyperlink that opens the specific worksheet.
Any ideas?
Thanks in advance