finders

  1. S

    Macro/VBA for finding data locations outside Excel

    Hi All, I have here a problem wherein I want to find the location of a certain data with no match outside Excel. Below are reference photo and explanation for clearer description of the problem. Here are the locations of the data that I will be putting in Excel. This is a sample of what's...
  2. S

    Find duplicates in column, then automatically deletes duplicates

    Hi All, I'm a beginner in terms of VBA and so I need help in finding duplicate data in columns then automatically deletes or selects them for deletion. Here's a macro VBA code I found on the internet but it only displays the word "duplicate" in another column. - Sub sbFindDuplicatesInColumn()...
  3. S

    VBA for finding duplicates values in a column and automatically selects it

    My problem here is there is already a VBA code for finding duplicates but the problem here is that. It still takes too much time to click all the duplicates 1 by 1 just to delete them, for example: Imagine a column filled with 5000 data and the duplicates found are around 1500, I can't possibly...
  4. A

    Correction in code to re arrange dat

    HI All the result of the of the macro is in tab Capitalisation Below macro filters the right data in Site_assumptions and arranges into Capitalisation tab Example AT2 Krottenbach Jul-71 New sites Nov-17 However i need to add in column F "Engineers" and "Site finders" per site and i don't...

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