Hello all, new to forums. Read through some vloopup threads and didn't see what I needed exactly. Below is my dilemma,
I need a script/macro that would let me transfer data from a column in Report 1 to Report 2. The conditions are,
1. Match by serial number between the two reports for the transfer. If there is not matching serial number in Report 2 then cancel transfer.
2. Data column blanks will not be transfer, only cells with data (text)
3. Possible to use two criteria as SN may occur more than once in the report (multiple service of same product). Maybe Failure Date.
File size of each report is around 100MB+. Thanks in advance
I need a script/macro that would let me transfer data from a column in Report 1 to Report 2. The conditions are,
1. Match by serial number between the two reports for the transfer. If there is not matching serial number in Report 2 then cancel transfer.
2. Data column blanks will not be transfer, only cells with data (text)
3. Possible to use two criteria as SN may occur more than once in the report (multiple service of same product). Maybe Failure Date.
File size of each report is around 100MB+. Thanks in advance