Maverick79
New Member
- Joined
- Jun 11, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello all. Hoping you can help a newbie to macros . I am trying to create a macro which will select and sort only the active cells in a table with headers across a set number of columns but with variable rows depending if there is any active data in the first cell of the row. I have tried to separate the steps and then combine by calling the next macro but run into errors. The first column should have no gaps in the list data, but the other columns may have blank cells. I want to select all columns based on number of rows with active data in first column and sort in ascending order by the last column (Month), but if month cell is blank this row should be last in sorted selection.
Thanks in advance for your help!
Order Number | Chassis | Brand | Month |
8888888 | 521345 | xyz | 1 |
9999999 | xyz | ||
7777777 | 854923 | abc | 8 |
Thanks in advance for your help!