Hi, I have data sorted by column A, which are employee names. There are many line items for each employee name. I need to parse out the data by employee name - I would like to select all of the rows for one employee and cut and paste the data into another workbook. I can create a new workbook but am having difficulty defining the selection for each cut.
Can someone help me in defining the selection for each cut? I don't have much right now:
Dim Associate As String
Dim MyCell As Range
Do While Range("A2") <> ""
Range("A1").End(xlDown).Select
Associate = Selection.Text
For Each MyCell In Selection
If MyCell.Value = Associate Then
Thanks!
Can someone help me in defining the selection for each cut? I don't have much right now:
Dim Associate As String
Dim MyCell As Range
Do While Range("A2") <> ""
Range("A1").End(xlDown).Select
Associate = Selection.Text
For Each MyCell In Selection
If MyCell.Value = Associate Then
Thanks!