macro to check if a value exist in a column and add it if it does not

[ml1221]

Hi experts,

I need help from you regarding excel vba. I'm a beginner in excel macro and I tried out many codes on the situation i have, it seems not working well.

I have 3 different files. I need a macro to go through the values row by row in column A & B in the "station_A" and "station _B" file respectively, and check if the value already exist in column A & B in "Master" file (check through the entire column to see if has repeated value). If it does, then show the address for that cell and continue on to the next one, if it doesn't exist then add both column A & B values in the "Master" sheet .

For example, I have a macro in "station_A" file. The first cell value in column A & B are "equipment 1" and "station A", the macro will check the values against the "Master" file. If the values already exist in the "Master "file, Msgbox will show the address. If it does not, the values will append to the "Master" sheet.

Same goes to "Station_B" file. If the values not found, it will append to the "Master" sheet.

Macro to be wrriten in "Station_A" and "Station_B" file only, no macro in "master" file.


Thank you in advance for helping to solve the problem !!!

[FDibbins]

nishaashokdhar you reported this thread as being unable to download the files. Both FlameRetired and myself were able to download/open them with no problems.

[ml1221]

Hi,
I have downloaded the files with no issues.
Has any expert know how to solve such Macro, Pls helpconfused:

Thank you.