User Input and export to a new worksheet

[beginner_2win]

Hi all,

How do you create a button in excel 2004 for a macro that will take in a variable from the user and output the result? For example, I have a worksheet with all the information such as, Date, School, Ambassador, Student, First Name, Last Name.,etc. Basically what I want to do is have the user input the the school name or date or ambassador and the search result should spit all the relevant information on the search on a New worksheet.

I'm thinking about having a menu box with opiton to select the crietera.

For Instance...

Ambassdor
Date
School
Student


So, if a user select "Ambassdor" he/she can then enter the value like "John" and do a search and spit out all the relevant info in a New Work sheet.

Please Advise,
Beginner

Thanks,
Beginner