Hi all
First of all - I've had excellent help from you guys in here, a few days ago with another VBA issue that I had. It was solved with a few lines of code within hours of posting the thread - AMAZING! Thank you so much!
So here goes for my second issue:
I've been trying to compare data from 2 columns (A4:500 & B4:500) in workbook1, sheet2 with data from column "F" (F4:500) in workbook2, sheet2. If there is a match in column "F" (workbook2, sheet2) from column "A" (workbook1, sheet2) on a specific row in column "F", then it should copy the text from column A row 3 (workbook 1, sheet2) to column "H", (workbook2, sheet2) to that same specific row. And if there is a match in column "F" (workbook2, sheet2) from column "B" (workbook1, sheet2) then copy the text from column B row 3 to the corresponding row in column "H"
I have "reg market" in A3 and "non-reg market" B3 for workbook1
and the idea is to compare 496 (could end up being more going forward) rows of stock from the two columns with imported data in column F in workbook2 and then indicate in column H if the stock is regulated or not
I hope it makes somewhat sense
Any help is much appreciated
Tnx
Dutch
First of all - I've had excellent help from you guys in here, a few days ago with another VBA issue that I had. It was solved with a few lines of code within hours of posting the thread - AMAZING! Thank you so much!
So here goes for my second issue:
I've been trying to compare data from 2 columns (A4:500 & B4:500) in workbook1, sheet2 with data from column "F" (F4:500) in workbook2, sheet2. If there is a match in column "F" (workbook2, sheet2) from column "A" (workbook1, sheet2) on a specific row in column "F", then it should copy the text from column A row 3 (workbook 1, sheet2) to column "H", (workbook2, sheet2) to that same specific row. And if there is a match in column "F" (workbook2, sheet2) from column "B" (workbook1, sheet2) then copy the text from column B row 3 to the corresponding row in column "H"
I have "reg market" in A3 and "non-reg market" B3 for workbook1
and the idea is to compare 496 (could end up being more going forward) rows of stock from the two columns with imported data in column F in workbook2 and then indicate in column H if the stock is regulated or not
I hope it makes somewhat sense
Any help is much appreciated
Tnx
Dutch