Please provide more details.
Current description is not clear.
You want to filter a list for a value user has entered in a cell?
Advanced filter see Debra Dalgleish's site.
http://www.contextures.on.ca/xladvfilter01.html
Gord Dibben MS Excel MVP
On Wed, 11 Nov 2009 11:56:03 -0800, Aashish
wrote:
how to assign cell value which the users has filtered by?