Hi All,
I'm self taught and have some pretty big knowledge gaps.
I'd like to compare the Column A in my "Master" worksheet with Column A in my "Compare" worksheet.
If a number is unique to Column A in my "Compare" worksheet I'd like to extract the information from the row and enter it into my result worksheet.
I have figured out how to get the unique value from the column in "Compare" into my "result" worksheet but I can't figure out how to get the entire row copied across.
In the screenshot below I've highlighted in yellow an example of the information that I would like to come across.
I've spent serious time traipsing around the internet looking for a solution to this one but haven't had any luck.
I'd really appreciate help.
I'm self taught and have some pretty big knowledge gaps.
I'd like to compare the Column A in my "Master" worksheet with Column A in my "Compare" worksheet.
If a number is unique to Column A in my "Compare" worksheet I'd like to extract the information from the row and enter it into my result worksheet.
I have figured out how to get the unique value from the column in "Compare" into my "result" worksheet but I can't figure out how to get the entire row copied across.
In the screenshot below I've highlighted in yellow an example of the information that I would like to come across.
I've spent serious time traipsing around the internet looking for a solution to this one but haven't had any luck.
I'd really appreciate help.