Hi,
What I'd like to be able to do is this:
1. Say I have a cell (A1) with a text entry, and A2 is blank.
2. If I then enter something into A2, I'd like A1 to go blank.
Seems like this should be extremely simple, but I've been trying to find some way to do this all day with no success. I'd like to have it in a formula, rather than a macro, as I want it to happen automatically when I enter something into A2.
Thanks
Bookmarks