delete used records from drop down list?

P

Prashant T

hi all!
i want the record(data entered in a cell) to be deleted once i use
it. It should not be present in the drop down list when i click in the other
drop down list containing the same records... For example if i select the
name "Jack" from the list for name1, it should be present in the drop down
list opposite to name2,the names apart from Jack should be there in that list.
Please suggest me a way.I would be very grateful to all those who
will provide me a solution and also to those who give it a try.
 
P

Prashant T

Dear Gord Dibben,
Thank you! I am very gratefull to you as you have
provided me the solution for my problem.I have gone through the solution and
executed it in my case and found it working perfectly.
I once again take this oppurtunity to thank you for
your timely help.

Thanks and Regards
Prashant T
 
G

Gord Dibben

Thanks for the feedback.

We are all grateful for Debra's hard work building and maintaining her site.


Gord
 
Top