Compare Sheet1 value to values in Sheet2 Column A
I am trying to date to no avail to solve this code.
I am trying to compare a cell value (G5) in sheet1 to see IF it is found in Sheet2 Column A
If it is i want to place other values in the SAME ROW in SHeet2
If it is not found, then i want to insert a New Row in Sheet2 and place the data into that new row.
I have not beed able to work out a code to be able to succesfully do this.
Any idea's?
CTM
|