Excel Macro for changing names

Hello Gavin,

Yes, the solution I gave you won't work if there are other columns containing the word 'Drama', so what I suggest is that you create a macro that follows the exact steps you outlined, except when you copy the cell which has replacement text down to the filtered cells below, make sure that you don't drag on the bottom right fill-handle... simply double click it which then copies all the way to the bottom cell.

Whenever you run the macro it will automatically include all the items in the filtered list. Your macro should also include clearing the filter after the name change has been done.

Give this a try!

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer