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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Incident_Problem[/TD]
[TD]Incident User[/TD]
[TD]Floating[/TD]
[TD]Application[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD]Incident_Problem[/TD]
[TD]Incident User[/TD]
[TD]Floating[/TD]
[TD]Application[/TD]
[/TR]
[TR]
[TD]Incident_Problem[/TD]
[TD]Problem User[/TD]
[TD]Floating[/TD]
[TD]Application[/TD]
[/TR]
[TR]
[TD]Incident_Problem[/TD]
[TD]SR User[/TD]
[TD]Floating[/TD]
[TD]Application[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Incident_Problem[/TD]
[TD]Incident User[/TD]
[TD]Floating[/TD]
[TD]Application[/TD]
[/TR]
[TR]
[TD]Incident_Problem[/TD]
[TD]Problem User[/TD]
[TD]Floating[/TD]
[TD]Application[/TD]
[/TR]
[TR]
[TD]Incident_Problem[/TD]
[TD]SR User[/TD]
[TD]Not Applicable[/TD]
[TD]Application[/TD]
[/TR]
[TR]
[TD]Incident_Problem_Lead[/TD]
[TD]Incident Master[/TD]
[TD]Floating[/TD]
[TD]Application[/TD]
[/TR]
[TR]
[TD]Incident_Problem_Lead[/TD]
[TD]Problem Master[/TD]
[TD]Floating[/TD]
[TD]Application[/TD]
[/TR]
[TR]
[TD]Incident_Problem_Lead[/TD]
[TD]SR User[/TD]
[TD]Not Applicable[/TD]
[TD]Application[/TD]
[/TR]
[TR]
[TD]Change_Asset[/TD]
[TD]Change User[/TD]
[TD]Floating[/TD]
[TD]Application[/TD]
[/TR]
[TR]
[TD]Change_Asset[/TD]
[TD]Asset User[/TD]
[TD]Not Applicable[/TD]
[TD]Application[/TD]
[/TR]
</tbody>[/TABLE]

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