VBA copy row of data based on column value

[fordmudslinger]

I have a spreadsheet that i would like to have a row copied from sheet 1 if the value in column f is "L" in that same row. then have the entire row pasted into sheet 2. Please help

 

[My Aswer Is This]

Try this:

When seeking help specific details are important:

Sub Copy_rows_in_a_table()
'Copy rows in a table
'Modified 11-29-17 12:55 PM EST
On Error GoTo M
Dim RngToCopy As Range
Range("Table2").Select
    ActiveSheet.ListObjects("Table2").Range.AutoFilter Field:=5, Criteria1:="L"
    Set RngToCopy = Selection.Offset(-1, 0).SpecialCells(xlCellTypeVisible)
    Selection.AutoFilter
    RngToCopy.Copy Sheets("Sheet2").Range("A1")
    Range("Table2").AutoFilter
    
Exit Sub
M:
    MsgBox "No Rows with your criteria found"
  End Sub

 

[fordmudslinger]

Perfect, thanks! I changed "Table2" to "Data" because that is the name of the table. I think you got "Sheet2" and the table name confused. Nonetheless, it works now! Thanks for your help. Sorry about the confusion with the table; I didn't know it made a difference, but I do now!

 

[My Aswer Is This]

Perfect, thanks! I changed "Table2" to "Data" because that is the name of the table. I think you got "Sheet2" and the table name confused. Nonetheless, it works now! Thanks for your help. Sorry about the confusion with the table; I didn't know it made a difference, but I do now!

Glad it worked for you.
And when you see Field:=5

That means the fifth column in your table
So if the first field is "B" then Field 5 would be "F"

 

[fordmudslinger]

Got it... thanks!