(not sure I have got the right title, anyway here is the question...)
If I can do this via formulae, I would much prefer this to VBA
I have two calls with text
A1: Cat
A2: Dog
In Cell A3, I want to have the value of either A1 or A2, dependent on which one was most recently edited.
1. If A3 started by displaying "Cat"
2. I input "Mouse" in A2
3. A3 now shows "Mouse"
4. I input "Horse" in A1
5. A3 now shows "Horse"
Many thanks
If I can do this via formulae, I would much prefer this to VBA
I have two calls with text
A1: Cat
A2: Dog
In Cell A3, I want to have the value of either A1 or A2, dependent on which one was most recently edited.
1. If A3 started by displaying "Cat"
2. I input "Mouse" in A2
3. A3 now shows "Mouse"
4. I input "Horse" in A1
5. A3 now shows "Horse"
Many thanks