PDA

View Full Version : Create Hyperlink and Copy data from files.



Venkat10
10-03-2018, 10:03 PM
Hi,

I have more than 50 excel files in folder and sub folders,I need to hyperlink files based on partial file name that I enter in sheet 1 of my Master file and copy sheet 2 data from all those files into my Master file sheet 2.
Sample file attached for reference.