Copy Row Based On Textbox Input

Hi Everyone,

I am looking for a little help with the VBA code in the attached Sheet that I have attached. I would like the user to be able to enter a site number into the textbox, hit the search button, the VBA code would the search column B of the data sheet for that number and copy the information from the corresponding rows cells cells B(Site Number) cell C (Site Name) and Cell F (Market). It would then return that information to be used in the CONCATENATE formula located in cell A8 of the subject line sheet. I did try to search working formulas and piece together one that would work but I have not had any luck thus far. Any help would be greatly appreciated.

and copy the information from the corresponding rows cells cells B(Site Number) cell C (Site Name) and Cell F (Market)

Where do you want to paste the information?

Here's what I got, see if it suit what you want.

Please Login or Register  to view this content.

Akuini,

Thank you for taking the time to take a look and help me out.

It could be pasted in row 5 of the subject line sheet. I was going to use the concatenate function to put everything together

Akuini,

Your code did exactly what i was looking for! Thank you greatly for your help with this!!!!

You're welcome, glad to help, & thanks for the feedback.