VBA that compares two cells and returns an indicator

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.

Hi,

Thanks - this is a good start!

However:
- I want the arrows to be dynamic - the user is going to put in values at a later stage. This can make the arrows change direction.
- Now the macro puts in arrows without taking into concern that the cell contains value, which makes it compare to empty cells.

Ok - I'll try 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.
If the cell doesn't have values, then nothing should be written.
The user must also be able to change values without running the macro again. Change of values could change direction of the arrows.

Then do the same in A2, A3, A4 and so on.