D
djm
I enter names in a row of cells (eg: A5:A7...Tom, Dick, Harry)
I then want to later enter Tom in A2 or A3...and enter Dick in
A4.....if I do this, I have to manually go thru A5 to A7 to erase Tom &
Dick (to avoid a double entry)............is there a non-VBA formula
(usable, perhaps, in Data Validation) that, as I go along entering the
names in cells A2 or A3, that will will look at he other cells (A5
through A7) and erase Tom from A5 or A7, and erase Dick from A4 .....so
that I don't have to do it manually?
I then want to later enter Tom in A2 or A3...and enter Dick in
A4.....if I do this, I have to manually go thru A5 to A7 to erase Tom &
Dick (to avoid a double entry)............is there a non-VBA formula
(usable, perhaps, in Data Validation) that, as I go along entering the
names in cells A2 or A3, that will will look at he other cells (A5
through A7) and erase Tom from A5 or A7, and erase Dick from A4 .....so
that I don't have to do it manually?