Here is the scenario: I have two worksheets named, Sample 1 and Sample 2. (see attachments to follow along).
There are three columns in both worksheets however Sample 1 is missing the data from columns B and C in Sample 2.
I can't just copy over columns B and C from Sample 2 to Sample 1 because Sample 2 has 1000's of extra SKU numbers in column A. Each SKU contains corresponding data in columns B and C. I've highlighted the extra rows grey in Sample 2 to show what I mean and I have attached a 3rd worksheet named "Sample 1 Desired Results" to show the results I am looking for.
The attached worksheets just contain about 20 rows as a small sample, but in reality these worksheets contain well over 10000 rows of data and to do this manually, it will take me forever.
If someone could advise me step by step what can be done to expedite this process rather than having to spend days doing this manually, it would be greatly appreciated.
Thank you in advance....
Bookmarks