Thanks for your help, but I knocked it out!! Only two macros needed! Thanks.

"L. Howard Kittle" wrote:

Send to


"Steve" wrote in message
...
Thanks for trying to help....
When a coworker opens an Excel file, I want Excel to first have the person
enter a number...
Once the number is entered, that number is matched from column A and the
sheet will only display the contents of that matched "row".
Am I making sense?
We just don't want to open the spreadsheet with all that data in thier
face
and have them search for their own stats.
Again thanks!