Hi again,
I want to make a VBA that checks if:
sheet "Q214",cell A1 has values.
If it has values then compares it with the value in sheet "Q114", Cell A1.
IF Q214>Q114, then ↗
IF Q214=Q114, then ↔
IF Q214<Q114, then ↘
The symbol should be in sheet"Q214" cellB1.
Then do the same in A2, A3, A4 and so on.
Bookmarks