compare worksheets

  1. sleek12

    Filter out from the range that is coloured green, use those values to open new worksheet to compare and contrast

    After the reconciliation was complete, The range gives out as values in both worksheets, values only in first worksheet and values only in second worksheet. (see last portion) But my area of interest is values in both worksheets. See below. ABCDEF1dec2021CASHBOOKdec2021NBK502BOTH2AmountCount...
    • sleek12
    • Thread
    • compare worksheets lambda reconciliation separate data
    • Replies: 1
    • Forum: Excel Questions
  2. B

    Compile one pricelist out of 20 Workbooks

    Here is my challenge. I receive about 20 pricelists from various computer suppliers with component pricing. I would like to compile one pricelist out of all of them. The challenge is however that that the sheets are not formated the same. Some suppliers go: ItemCode| Price | Description...
  3. S

    Compare Worksheets and Delete

    Hello Everyone, I have two worksheets from two different sources that contain mailing addresses. I need to compare the two worksheets and separate the addresses that have no match. I have looked at a macro that gave me a quarter of what should be there. Please help! Thanks Abby
  4. D

    Need help with =IF([WB1.xls]Sheet1!A1<>[WB2.xls]Sheet1!A1,"Different",""), can I highlight the different cell with cells values in it as result of for

    I am going to create a workbook to do a comparison between two different workbooks so I do not have to open the other workbooks, and I was wondering, can I make it change the coloring of the cell and show the contents of the cell? WB1 will always be the newer workbook, so changing the formula...
  5. D

    Compare and Delete

    Dataset 1 Workbook 1 (name varies)--> Worksheet 1 --> Column A --> Cell 2 thru (varies - can be hundreds or thousands) Dataset 2 Workbook 2 (Rlistsort) --> Worksheet 1 --> Column A --> Cell 2 thru (currently 250 but will continue to increase) Need to compare Column data in Workbook 1 to Data...
    • DanielMc
    • Thread
    • compare columns compare worksheets delete duplicates delete rows duplicate
    • Replies: 0
    • Forum: Excel Questions

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