hi,
please help in getting a macro where it need to search for 2 fields and get data - i.e
in my excel sheet i will be having BU col and CPN col. it need to go to a link and from that site it need to go to the perticular BU folder and search for the CPN file, and get that file location(link), copied and pasted in this excel file.
please help in getting a macro where it need to search for 2 fields and get data - i.e
in my excel sheet i will be having BU col and CPN col. it need to go to a link and from that site it need to go to the perticular BU folder and search for the CPN file, and get that file location(link), copied and pasted in this excel file.
