Macro for Multiple Find and Replace in Excel

I looked at list of BU but only found the code and the name. Do you need to toggle between these two?

Your List of BU's only has the H0041 number and company name. It doesnt have the 40. That being said your code would be something like:

Please Login or Register  to view this content.

Based on the replacement values being in column C in the List of Bus sheet.

Thank you and apologies for the confusion over s/s.

Example.xlsm

I've now re-attached a more simplified version of s/s. I have also added in it the macro that yudlugar recommended with the slight edit of changing the replacement range to column B rather than C, so it is as below:

Sub Replace()
Dim count
For count = 2 To Sheets("List of BUs").Range("A" & Rows.count).End(xlUp).Row
Sheets("Management Contract").Cells.Replace What:=Sheets("List of BUs").Range("A" & count), _
Replacement:=Sheets("List of BUs").Range("B" & count)
Next
End Sub

However, whilst this works in replacing the values in the first tab (which is what I want), it also seems to replace the values in tab "List of BUs" as well, whereas I just want to limit the find and replace to the first tab (hopefully this will make more sense if you actually run the macro as attached). Not sure if a slight tweak is needed in the macro?

Also, any macro in doing the reverse - i.e. doing a find a replace from company name to company code. Ideally I'd like two macro that both refer to the one list in "List of BUs" tab.

Many thanks for help

Sorry, I've reattached (see penultimate post) a more simplified s/s, but in essence yes, I need to toggle between code and name. Thanks.

Originally Posted by rcm

I looked at list of BU but only found the code and the name. Do you need to toggle between these two?

*bump*

Would be grateful for any further help on this...?

Can you please attach the document...