Hi - I just stumbled onto this forum while Googling around, and it looks great. I'm pretty new to VBA coding so please bear with me.Effectively what I'm looking to do in this mock-up file, is anywhere the currency is "EUR" in column A, I'd like the relative cell in Column G to change to "INSERT TEXT", else I want it to untouched (i.e. to keep the comment it currently has). I've tried messing around with loops, but keep getting stuck. Would really appreciate any help, if someone has the time.
Many thanks.
Bookmarks