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.

See Debra Dalgleish's site for help with this.

http://www.contextures.on.ca/xlDataVal03.html


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 05:28:02 -0700, Prashant T <Prashant
wrote:

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.

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

"Gord Dibben" wrote:

See Debra Dalgleish's site for help with this.

http://www.contextures.on.ca/xlDataVal03.html


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 05:28:02 -0700, Prashant T <Prashant
wrote:

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.

Thanks for the feedback.

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


Gord

On Fri, 4 Aug 2006 00:03:01 -0700, Prashant T
wrote:

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

"Gord Dibben" wrote:

See Debra Dalgleish's site for help with this.

http://www.contextures.on.ca/xlDataVal03.html


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 05:28:02 -0700, Prashant T <Prashant
wrote:

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.