Jtucker10278
Board Regular
- Joined
- May 14, 2017
- Messages
- 55
So Oh Holy ____!
I wish i would have known this 75 hours ago when i started making this beast of workbook
I have a list of 75 names in Column A
and for each name there is a named range for that row
<tbody>
</tbody>
B2:G2 = John (named range)
B3:G3 = James (named range)
ect ect ect
Now lets say I want/need to sort the names (and their respective date) alphabetically.
The names Sort, The data sorts, but the named ranges do not sort.
Any thoughts?
Thanks
I wish i would have known this 75 hours ago when i started making this beast of workbook
I have a list of 75 names in Column A
and for each name there is a named range for that row
A | B | C | D | E | F | G | |
1 | Wk1 | Wk2 | Wk3 | Wk4 | Wk5 | Wk6 | |
2 | John | 10 | 12 | 9 | 13 | 15 | 7 |
3 | James | 6 | 5 | 7 | 8 | 4 | 2 |
4 | David | 9 | 8 | 6 | 7 | 9 | 8 |
5 | Lamont | 3 | 2 | 6 | 2 | 3 | 5 |
6 | Dustin | 1 | 5 | 2 | 4 | 8 | 5 |
7 | Dan | 1 | 2 | 6 | 4 | 8 | 7 |
<tbody>
</tbody>
B2:G2 = John (named range)
B3:G3 = James (named range)
ect ect ect
Now lets say I want/need to sort the names (and their respective date) alphabetically.
The names Sort, The data sorts, but the named ranges do not sort.
Any thoughts?
Thanks