Hello,
Currently I'm copying group data range by JOB ID from Sheet1 to Sheet2. So table for example please see below:
Grouping JOB IDs then sending them to Sheet2. This works fine as a group at a time when requested.
Once the data has been sent to Sheet2 it needs to sort by LENGTH + JOB IDs (ex JOB ID: 900)
The issue is:
900 is grouped and sent, then the 750 is grouped and sent straight after - I have no idea how to break this down and sort by length per JOB ID as an overall filter will destroy the JOB by JOB scenario.
I'm currently using to group my data.
With Sheets("Sheet1").UsedRange
.AutoFilter
.AutoFilter Field:=23, Criteria1:="C15015"
.AutoFilter Field:=25, Criteria1:="JOB SCHEDULED"
.Offset(1).Resize(.Rows.Count - 1).SpecialCells(xlCellTypeVisible).Copy OB.Sheets("Sheet2").Cells(erow, 1)
.AutoFilter
End With
<tbody>
</tbody>
Currently I'm copying group data range by JOB ID from Sheet1 to Sheet2. So table for example please see below:
Grouping JOB IDs then sending them to Sheet2. This works fine as a group at a time when requested.
Once the data has been sent to Sheet2 it needs to sort by LENGTH + JOB IDs (ex JOB ID: 900)
The issue is:
900 is grouped and sent, then the 750 is grouped and sent straight after - I have no idea how to break this down and sort by length per JOB ID as an overall filter will destroy the JOB by JOB scenario.
I'm currently using to group my data.
With Sheets("Sheet1").UsedRange
.AutoFilter
.AutoFilter Field:=23, Criteria1:="C15015"
.AutoFilter Field:=25, Criteria1:="JOB SCHEDULED"
.Offset(1).Resize(.Rows.Count - 1).SpecialCells(xlCellTypeVisible).Copy OB.Sheets("Sheet2").Cells(erow, 1)
.AutoFilter
End With
| JOB ID | Cust Name | Qty | Length | TYPE | Status |
| 900 | Luke | 5 | 3700 | C15015 | Job Scheduled |
| 900 | Luke | 8 | 5200 | C15015 | Job Scheduled |
| 750 | Mary | 4 | 2400 | C15015 | Job Scheduled |
| 750 | Mary | 4 | 7200 | C15015 | Job Scheduled |
| 400 | John | 2 | 5000 | C15015 | Job Scheduled |
<tbody>
</tbody>
Last edited:
