I have around a thousand files in excel 2007 sheet that i need to hyperlink it a different folder in our server, is there a macro that i could used so that i could hyperlink it in one time? and how will i add that macro in my excel sheet, i dont know much about macro.
Some of the folders in the server are : Correspondence, transmittal, RFI etc.and in my excel sheet all transmittal, rfi and other correspondence are just in one excel sheet. I have attached a sample excel sheet for you to see what i need.
Please help me............
Thanks in advance
estman
Bookmarks