I am hoping someone can help me. I need to finish this project tonight and I am running out of options. I am HUGE newbie, so I will try to explain what I am looking to do.

I have data in one worksheet. The data is information from companies that are providing specific information about themselves. Each company has a unique identifier, being their supplier code.

In another worksheet, I have a template that needs to populate using individual company's data. So for instance, if I'm in the template worksheet and I type in the Supplier Code 123, then I need the template to automatically populate with that company's data. Then, If I choose another Supplier Code, 567, then the template needs to update with that company's data.

I hope I'm making sense. Any help would be GREATLY appreciated.