Excel Help - What is it called when ... (see .gif )

[qdada]

I am trying to create; for a lack of correct terminology I call it a filter; where u select an item from some lookup and that item disappears from the look up next time you lookup again. I am describing it poorly so I created this .gif using camtasia to illustrate.

I basically manually deleted the records after each select and deleted those frames to create an illusion for what I am trying to create.

I hope you follow.

 

[chunk10]

Just looks like a drop down list

 

[cyberbob1979]

I have no idea - but I suppose it has to be a named list in Excel with an IF filter in place to check for the value already in use... *something* like that might work

 

[The_MAC]

Just looks like a drop down list

with disappearing rows based on selection.......

 

[The_MAC]

Don't ask me how, but this is definitely a job for a Macro

 

[chunk10]

with disappearing rows based on selection.......

Aah yeah not that simple

 

[Xino_sam]

Not a macro - It is data validation, this option is listed on the Data Menu, further you have to select List on the Allow menu

 

[ABCpt]

If I understand correctly, this is what you are looking for:
http://www.contextures.com/xlDataVal03.html

 

[qdada]

If I understand correctly, this is what you are looking for:
http://www.contextures.com/xlDataVal03.html

Thank you, thank you, thank you so much. That is exactly what I meant.

 

[ABCpt]

Thank you, thank you, thank you so much. That is exactly what I meant.

Glad I could help.

 

[Thor]

Homework done.