How can I compare to columns (on different spreadsheets in the same workbook) that may have the same data (string value) and then enter in another value from a column that contain data.
Column A Column b
What I need to do is compare the sheets and move column b to sheet 1 column b
The sheets may not be in the same order or one sheet may have more than the other
Is there a formula that can do this or is there a quick macro that can accomplish this
Thank you for all of your help in advance