I have a spreadsheet with multiple parts on one sheet. Each part has a different number of rows, but the key column is always the same.
I want to be able to highlight the relevant range, then invoke a macro to sort that range. Then I want to highlight another range and invoke the macro to sort only that range, etc.
This is a mock up of what I'm looking to do. I want to highlight a range (Task through last Hours), then invoke the macro to sort by Hours.
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
I want to be able to highlight the relevant range, then invoke a macro to sort that range. Then I want to highlight another range and invoke the macro to sort only that range, etc.
This is a mock up of what I'm looking to do. I want to highlight a range (Task through last Hours), then invoke the macro to sort by Hours.
Site 1 | ||
Task | Assigned | Hours |
Job1 | Smith | 25 |
Job2 | Jones | 32 |
Job3 | Silver | 15 |
Site 2 | ||
Task | Assigned | Hours |
Job1 | Smith | 25 |
Job2 | Jones | 32 |
Job3 | Silver | 15 |
Job 4 | Wilson | 8 |
Job 5 | Smith | 12 |
Site 3 | ||
Task | Assigned | Hours |
Job1 | Smith | 25 |
Job2 | Jones | 32 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>