Duplicating cells down a column by an amount expressed in a single cell.

[Austin7sims]

I'm not sure how to ask this without just jumping into the problem... So here it is:
I have a table that has door types and corresponding info for said door types. that data is linked to another table that has a drop down. So if you have 3 "Type A"s and 6 "Type B"s, you only need to type the info once, then select "Type A" 3 times and "Type B" 6 times from the drop down. My problem now is I want to add a "Number of Doors" column. So instead of having to select Door Type A 100 times, I can just type "100" in the cell and it will populate the info for Type A 100 times in the main table. I have tried everything I can think of to do this but can't figure it out.

 

[James006]

Hi,
You can adapt the following Event macro

Private Sub Worksheet_Change(ByVal Target As Range)
' String located in cell A1 and Total Number of Rows in cell B1
If Target.Count > 1 Then Exit Sub
If Target.Address <> "$B$1" Then Exit Sub
Range("A1").Copy Destination:=Range("A1:A" & Target.Value)
End Sub

 

[James006]

Glad to see you liked the code ... and that it could help