I'd like to compare 2 columns from different worksheets in the same workbook with a twist...
Here's what I'd like to do..
If any and all data from worksheet 2-column c matches any and all data from worksheet 1-column c, then go back to worksheet 2-column B on the same data matching row, copy the data from that cell and paste it into the same row of the data match in worksheet 1-column b and paste it.
Can this be done?
Thanks much in advance