compare 2 sheets

  1. P

    Compare Workbooks

    Hello folks, I am not an expert at excel, so not sure how to resolve this issue. I have two excel worksheets: File 1: Subset: This file has a subset of employees with various details including training status such as in-progress, completed, etc. File 2: Full-Pop: This file has a complete...
  2. M

    Comparing sheets

    Hi, I need to maintain a list of clients for a specific purpose. For this I receive a daily report with a list of clients that fit into this criteria and I need to identify when the daily report and the clients it contains changes. I need to identify when clients appear on the report as well...
  3. T

    VBA to Compare sheets, and insert missing data, while skipping over existing items that may be in master list

    I am attempting to compare lists of data and insert missing rows. The below code is intended to do so, however, if it encounters an items in the Account Master List that is not on the Execute billing list it will insert rows for everything that comes after that row of data. Any help is...
  4. S

    Find Differences Between Worksheets and Export to Third Worksheet

    Hello forums, I have a dream of an Excel macro or tool that would make my job infinitely easier, but attempting to cobble it together on my own from Google and forum posts has not proved fruitful. One of my job duties is to take reports that are exported nightly and compare them to determine...
  5. H

    Urgent Excel Help Needed Again!

    Hi Guys, I am trying to determine whether a combination of values contained in cells within one sheet exist in any row contained within another sheet i.e. are ALL of the values contained between cells A2-BB2 in 'Sheet 1' equal to ALL of the values in ANY row contained between cells AZ-BB2 in...
  6. B

    Compare two sheets for differences with results on sheet 3

    Hello all, I am trying to develop a script that would compare sheet 2 to sheet 1, with differences on sheet 3. I am trying to find out when my customers are advancing orders within standard time. Below is the small piece of last two order sheets. Sheet1: <tbody> </tbody> <tbody>...
  7. S

    Loop items in one sheet and match to items in another sheet

    I am trying to loop through the items in SampleData2.xlsx and match them to the items in SampleData1.xlsx. If the item matches, I want to take the price and put it in the Column labeled "Complete". If anyone could offer some guidance, it would save me hours and possibly my sanity. Is this...

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