I have a spreadsheet with various clients names, phone numbers, etc on Sheet 1. Each client has an ID number assigned in Column A and the data I need is in various cells in one row (eg: Name is in C9, ph. # is in D9, email is in H9). Sheet 2 has a form that gets printed out and given to the clients. I would like to have a macro or VB code to fill in the name, phone number etc. on the form based on which client is selected from Sheet 1. What I've got so far is an Input box where I input the client ID number. However, I've been unable to use this variable in the various cells on the form to fill in names, phone numbers, etc. What I was hoping to do is something like this:
='Sheet1!'vairable9 if I had entered 9 in my Input box.