View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Basta1980 Basta1980 is offline
external usenet poster
 
Posts: 102
Default Search data w. use of msg box and copy results to new blanc worksh

I have a worksheet named abc. It consists of clien information (a/s/l/,
commitment of contract, service used etc.) What I'd like to do is filter out
all users who have a commitment of x-number of months. The x-number is a
variable and I want to use a msg box to specify the amount of months I'm
looking for (i.e. 24 should mean find all users with commitment of 24
months). After Excel executes this search I want excel to copy the users who
match the requirements to be copied into a blanc worksheet. Is this
possible?! The number of months is located in cel M.