islands

Hi I have the following macro which was working but when I add it to a button I get an error message saying Ambiguous Name: Multi_FindReplace when I click the button to run the macro. when I debug the row with orange text below is highlighted in yellow. I would be grateful if you could please...

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()...

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...

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...