Hello Excel community, thank you for taking the time to read my question!

I have Table1 (EventTable) that looks like this: https://i.imgur.com/on5CHlr.png

The table has no headers and is actually dynamically expanding based on the code that the user writes. In the picture, there's a sample code that a user has written.

The user can tag references into the code by selecting them from the "code" column of Table2 (EventReferenceTable) that looks like this: https://i.imgur.com/MGkXh2q.png

When the user has finished writing their code, I want them to be able to run a VBA script that finds every instance of a "code" being used from EventReferenceTable, and then replaces it with its equivalent "formula" value.

I then plan to edit the VBA slightly to add an equal sign right before the newly replaced value so it becomes an actual formula, and boom!

Someone has already provided me with a little bit of VBA that "loops through every cell of EventTable and prints a debug" or something, but no one has any clue on how to find-and-replace with the values from another table.

Thanks everyone!