I need help to hyperlink images to multiple excel files based on cell value for example i have few file A,B,C,D,E,F excel files and 1,2,3,4,5,6 in exact cell X-2 value for all the excel files with same number images in it's root folder and i need to auto hyperlink through macros or vba or anything else... I have like 80000 excel files to fill data. Please help needed urgently.