comparing worksheets

  1. C

    Help matching new columns with slightly different text

    <colgroup><col><col></colgroup><tbody> Available grants Published Measuring productivity Services Data Set Census data Data Security Activity data Monthly analysis on last census Work Assessment Organisation Reference Data Smoking habits of adults Adult smoking Risk management...
  2. M

    Comparing two worksheets

    Hello, I am using this code listed below to compare two worksheets using VBA. The data on the worksheets are numbers with many decimals. However, I only want to compare up to the first four decmial places (.XXXX) and do not care if there are differences smaller than that. When I am running my...
  3. J

    Comparing Worksheets

    I have a user that needs to compare MSExcel files with a mass number of worksheets within the file/files. Is ther anything to compare Excel files and to print out the compared results? Thanks, Jess
  4. L

    Compare to worksheets using VLOOKUP and IF

    Hi I have 2 worksheets that I need Excel to compare I can assign it 1 ID to look at on each worksheet. I don't know how to write the Vlookup and maybe the IF statement that will give me a column of the data that did not match. Signed I give up.

This Week's Hot Topics

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
Top