Hey guys,
So I'm very new to Visual Basic so I apologize in advance for any obvious things that I'm missing. I'm working on a tool for price estimation that will allow people to enter the number of pages in a project and the number of interviews for a project into a user form, and then have the user form create a new sheet containing information from prior projects with the same page and interview numbers.
Ive already got the user form together, where I'm stuck is writing the code to take the page and interview numbers entered by the user to look up matching values in my data sheet, and then copying over the entire row from the results found back into my new sheet. Since there will be multiple matches, I can't figure out how to get v-lookup to work. Should I be using Index/Match code or is there some way to get multiple results from v-lookup? Thank you so much in advance for any help
So I'm very new to Visual Basic so I apologize in advance for any obvious things that I'm missing. I'm working on a tool for price estimation that will allow people to enter the number of pages in a project and the number of interviews for a project into a user form, and then have the user form create a new sheet containing information from prior projects with the same page and interview numbers.
Ive already got the user form together, where I'm stuck is writing the code to take the page and interview numbers entered by the user to look up matching values in my data sheet, and then copying over the entire row from the results found back into my new sheet. Since there will be multiple matches, I can't figure out how to get v-lookup to work. Should I be using Index/Match code or is there some way to get multiple results from v-lookup? Thank you so much in advance for any help
