How to combine two worksheets into one. Only ONE column is common.

E

Ellie

Hello everyone. In advance, thanks for your help.

I have two worksheets in one workbook. Only one column is common between
both worksheets - this column contains data for Part Numbers from one source.
The second sheet contains data for these Part Numbers from another source -
but not all Part Numbers are represented within this worksheet.

What is the fastest way to combine the data within both worksheets into ONE
worksheet? I want all Part Numbers to be contained, whether there is data
from the second worksheet or not.

Thank you SO MUCH for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top