|I am making a form that will act as a Rolodex. In the first box, you will put in a name or location, and then hit a find button. Below that, I then have Headers named Number 1, Number 2, and Number 3 with three text boxes underneath that which will populate with different numbers. |
I have listed the locations in a different spreadsheet in row A with Number 1 in row B, number 2 in row C, and number 3 in row D.
How can I write a macro that when I put a location in my first box it will search the second spreadsheet in row A and then populate the boxes with the phone numbers from that same worksheet from the different rows? Any ideas?