compare 2 worksheets

  1. B

    Highlight the Dupicates from two work sheets

    Hi to all.... Am a new person to Excel macro. my prob in excel find out the duplicates from two excel sheet. In my sheet1 have Lot of customer names and them Area in a Column A and B.Then my sheet2 have customer name and them Area in column A and B.The Sheet2 data are existing in my...
  2. A

    Combining two spreadsheets into a third

    Okay, I've been pounding my head against this one for eons, so I now come to you, masters of all things Excel, begging for assistance! I have two spreadsheets, one far larger and more complete than the other. There are multiple columns that overlap between the two. What I need to do is...
  3. E

    How to compare and highlight differences in 2 spreadsheets?

    MS Word has a built in feature. Does MS Excel also have such a built in feature? If yes, where? If no, I see there exists third-party software add-ins that display and highlight the differences when comparing 2 spreadsheets. Which would be a good and free one?
  4. J

    Compare 2 worksheets of same size and highlight changes in different colour

    I am completely new to VBA. I have 2 worksheets of the same size (about 4000 rows), cells containing either text, time or date data. I need to compare the new worksheet with the old and highlight anything that has changed on the new with a different colour. I currently do the exercise in...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top