View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Durai Durai is offline
external usenet poster
 
Posts: 7
Default Macro to ask for a item# and then show all details for that item

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