Hi,

Might consider using an autofilter instead of a macro - Data, Filter, Auto
Filter. Then open the filter in the Item# column and pick any number.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Durai" wrote:

i have details for parts in excel. Like to have a macro that will ask the
user for a item number and shaw all details for that item
example
Item# purchase sold date region
a0012 1200 400 12/12/09 Ont
b1115 500 200 12/01/09 Ont
a0012 300 50 12/05/09 Aberta
a0012 400 25 12/08/09 Ont

Thanks for any help