Hello All,
I'm new to Excel and have hit an issue that i'm sure is very easy to correct, but has me stuck.
I have a simple macro in VBA that changes a cell value based on a different cell's value. I need to apply this rule to all columns in my worksheet:
If Range("I4").VALUE = "Text 1" Then Range("J4").VALUE = "Yes"
If Range("I4").VALUE = "Text 2" Then Range("J4").VALUE = "No"
Any help would be appreciated.
Most kind.
Bookmarks