Row auto population based on value selected in drop down

[webmunky]

Hi all,

New here and pretty new to Excel formulas and VBA, so bear with me...

when I select a value from a drop down in column B on sheet 1 I need a lookup to a table in sheet 2 to loop through the table and set all the rows on sheet 1 where A1 matches in sheet 2 A1. the number of rows can change so for example in the below tables, I manually select "Incident_Problem" in table 1 column 1, I need the values from table 2 populating as they appear in table 2, in table 1.

Incident_Problem	Incident User	Floating	Application

<tbody>
</tbody>

Incident_Problem	Incident User	Floating	Application
Incident_Problem	Problem User	Floating	Application
Incident_Problem	SR User	Floating	Application

<tbody>
</tbody>

The data in table 2 will change look more like this:

Incident_Problem	Incident User	Floating	Application
Incident_Problem	Problem User	Floating	Application
Incident_Problem	SR User	Not Applicable	Application
Incident_Problem_Lead	Incident Master	Floating	Application
Incident_Problem_Lead	Problem Master	Floating	Application
Incident_Problem_Lead	SR User	Not Applicable	Application
Change_Asset	Change User	Floating	Application
Change_Asset	Asset User	Not Applicable	Application

<tbody>
</tbody>

So I need the lookup to do the loop / count, and auto populate the number of rows for each value:
select Incident_Problem & it creates 3 rows of data, select Change_Asset & it creates 2.

I also need it to be repeatable down the spreadsheet - there will be multiple selections of the same value.

Hope that makes sense & is possible!

Thanks