Populating area of a worksheet

[Schwyl]

Hey Every . I've tried searching but I'm not even sure what I want to call what I want to do.

I'm wanting to create a worksheet that based on the selection in a dropdown menu will populate rows based on a cell match.


DataSheet

Data1	Data2	Data3	Data4	Data5	Data6	Data7
Thing1	Stuff1	Stuff2	Stuff3	Stuff4	Stuff5	Stuff6
Thing2	Stuff1	Stuff2	Stuff3	Stuff4	Stuff5	Stuff6
Thing3	Stuff1	Stuff2	Stuff3	Stuff4	Stuff5	Stuff6

Fancy sheet

So I want this to have a Drop Down with a list of thing 1,2,3 Depending on which one is selected I want any row that has it in column A to be populated on my other sheet.

 

[jolivanes]

Change references as required.

Sub Maybe()
Dim sh1 As Worksheet, sh2 As Worksheet, c As Range
Set sh1 = Worksheets("From_Sheet")
Set sh2 = Worksheets("To_Sheet")
    For Each c In sh1.Range("A2:A" & sh1.Cells(Rows.Count, 1).End(xlUp).Row)
        If c.Value = Cells(1, 2).Value Then c.EntireRow.Copy sh2.Cells(Rows.Count, 1).End(xlUp).Offset(1)
    Next c
End Sub

If your data range is large, autofilter should be faster.

 

[jolivanes]

Just wondering. Have you had time to try it yet and if so, did it work?

 

[Schwyl]

Just wondering. Have you had time to try it yet and if so, did it work?

Sorry got tied up in hazops. This weekend im going to try and get to it

 

[Schwyl]

Just wondering. Have you had time to try it yet and if so, did it work?

Hi there, It worked for how I described it. Thank you

 

[jolivanes]

Thank you for letting us know. We can now delete the test workbook.
Good Luck