I want a macro that will check values in the K column and copy the rows that contain "F" to a new worksheet and the rows that contain "G" to another new worksheet. This seems simple, but I am at a loss.
You will need to change the ranges and sheet names in the code below!
Note, you may also remove the code to copy a range from the "Vendor" sheet as well as it does not apply in your case. JSW
'Find all the rows ("A:G") that have a "X" in column "A" copy
'that row to the next blank row on a different sheet.
Application.ScreenUpdating = False
For Each r In Worksheets("Want_Full").UsedRange.Rows
n = r.Row
If Worksheets("Want_Full").Cells(n, 1) = "X" Then
Worksheets("Want_Full").Range(Cells(n, 2), Cells(n, 7)).Copy Destination:=Worksheets("Want_Now").Range("B65536").End(xlUp).Offset(1, -1)