Combining Worksheets with inconsistent data

T

Teufel

I have two large worksheets that need to be combined.
There is one field / column on each worksheet that is
common between the two worksheets; however not every line
matches because each worksheet has some unique records in
this field / column. Is there a way to line up matching
rows only?
 

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

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
matching & combining data from seperate worksheets 2
Space at end of multi page list to accommodate new entries 1
Match Function 1
VBA word change keys 0
Needs help combining functions. 3
Combine files 1
Style Gallery View 3

Top