Compare Data across worksheets, list differences in 3rd sheet

T

trawets

I have looked for this solution and I’m sure its there but I have been
unable to locate it
Basically I have two worksheets, identical format, I would like to
compare the rows of data in each sheet and place the found data into a
3rd blank worksheet. This can be reduced to comparing 1 column in each
sheet i.e. Part Number but I would require the whole row of data to be
placed in the 3rd sheet, with some sort of Identifier to which sheet
the data came from.
I’m not sure how clear this is, if further clarification is required
please ask.
Thanking you in anticipation
 

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

Conditional Formatting to Compare Two Sheets of Data 1
Compare 2 Pivot Tables 2
How? compare two worksheets and identify rows of data that appear on both. 9
Mandatory Cell completion for multiple worksheets in a workbook 0
How to compare worksheets so differences are identified 1
Create 3rd data set off comparison of 2 other sets 2
Comparing two worksheets and highlight unmatched Data 0
data to summary sheet for a dummy 0

Top