saint

  1. I

    Find

    I have two columns, I want to search for the cities in the 2nd column and highlight those cities in the 1st column. <colgroup><col><col></colgroup><tbody> ARBYRD MO ARBYRD MO ARBYRD MO HORNERSVILLE MO ARBYRD MO COOTER MO ARBYRD MO HOLLAND MO ARBYRD MO CARDWELL MO AVA MO RIVES...
  2. L

    Macro to run on all columns except column H

    Hi I have a macro below which find and replaces countries with reference numbers which is working ok however I need to exclude column H, I have tried adding the range line below but it is not working and I keep getting error message, I would be grateful if any advice. Sub Multi_FindReplace()...
  3. L

    Edit macro to search specific column in sheet not all active sheets.

    I have the following macro which I have edited and would be grateful if some could please help me edit it so it only looks sheet1, also have I done this correctly so that it will find and replace? Sub Multi_FindReplace() Dim sht As Worksheet Dim fndList As Variant Dim rplcList As Variant...
  4. L

    Macro: If X then return Y on next sheet.

    Hi, I have a two sheets and I need to copy data from sheet one and paste it in sheet 2, the issue is that each contact on sheet 1 has a field called country of birth which is fine however to use that information and paste it next to their record on sheet 2 but with a reference number instead...
  5. A

    Formula to copy from one column to another but if the info is the same copy info once then lave other cells blank

    I am looking for a formula to copy from one column to another but if the info is same copy info once then lave other cells blank. Example below Column A -----------------------------Column B OBSESSION by Calvin Klein----------OBSESSION by Calvin Klein OBSESSION by Calvin Klein OBSESSION...

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