Hello all, I am trying to find a way that will allow me to copy an entire row
of data from one sheet to another based on matching values. Hard to explain,
see below.

Sheet 1 Sheet 2
A B C A B C
1 a 1 2 1 b 3 4
2 b 3 4 2 c 5 6
3 c 5 6 3 a 1 2

So, if on Sheet 2, column A has a "b", it will find "b" in Sheet 1 (only in
column A) and copy the entire row from Sheet 1 to Sheet 2.

Further info, there may be values in Sheet 2 that will not match what is in
Sheet 1, in that case I would like those cells to remain blank. Thank you for
the help!