Subject: Management Information Systems

I need help with creating excel macros if possible. I have attached a photo of what my data base looks like. I want to add different macros so that like a text box pops up asking the following (As diff macros, diff buttons):

• Please enter Customer ID
• Please enter Customer Name
• Please enter Customer Location

When it is entered in the text box, I want like only the rows with that information to show. And then, a macro to be able to clear after each search. It would be greatly appreciated if you could help me with this.

A B C D E F G H 1 Customer |Customer Nan |Customer Location Amount Order | Flowers Order | Payment Accept | Purchase Order | GPS Locatiregistered in Loyalty Progra 1357 Janice. K. Ruthven 10 Gardenias Yes 123 Yes 2468 Marissa. W. Wheatley 5 Roses Yes 321 Yes 3579 Alice. S. Leamington 2 Daisies Yes 534 No 4680 Patricia. F. Windsor 5 Lilies Yes 862 Yes 5791 Elisa. M. Kingsville 4 Carnations Yes 525 No 6801 Mike. B. Windsor 8 Tulips Yes 712 Yes 8 7913 Sam. J. Lakeshore 12 Sunflowers Yes 358 Yes 9 8024 Arthur. E. Essex 4 Alstroemerias Yes 348 Yes 10 9135 Nicholas. B. Windsor 1 Hibiscus Yes 120 No 11 12 13 14 15