i am working on a VBA that should find a match in the table column A of sheet 1 and match it in a table on sheet 2 and select column 6 cell value.
but when i run the code it selects the wrong row and value. what i'm i doing wrong.
Dim ws1 As Worksheet
Dim ws2 As...