Beatrix
10-15-2014, 03:43 AM
Hi Everyone ,
I need to put the rows and columns in a specific order in multiple tables in excel. Is there any time saving way to do this with VBA?
What I need is put the Rows in order 5A, 5B, 5C, 4A, 4B, 4C, 3A, 3B, 3C, B or N
Also Columns need to be reversed as U, G, F, E, D, C, B, A, *
Column 2SK should stay as it is.
I attached before after scenarios.
PS: In original spreadsheet there are 2 tabs and each tab has multiple tables.
Cheers
B.
Sub Level
2SK
*
A
B
C
D
E
F
U
3A
9
3
3
1
3B
9
1
3C
8
4A
4
1
4
14
13
6
4B
9
2
10
22
10
2
4C
8
2
14
7
3
1
5A
1
5B
2
4
1
5C
1
1
16
20
4
2
B or N
15
2
3
1
1
I need to put the rows and columns in a specific order in multiple tables in excel. Is there any time saving way to do this with VBA?
What I need is put the Rows in order 5A, 5B, 5C, 4A, 4B, 4C, 3A, 3B, 3C, B or N
Also Columns need to be reversed as U, G, F, E, D, C, B, A, *
Column 2SK should stay as it is.
I attached before after scenarios.
PS: In original spreadsheet there are 2 tabs and each tab has multiple tables.
Cheers
B.
Sub Level
2SK
*
A
B
C
D
E
F
U
3A
9
3
3
1
3B
9
1
3C
8
4A
4
1
4
14
13
6
4B
9
2
10
22
10
2
4C
8
2
14
7
3
1
5A
1
5B
2
4
1
5C
1
1
16
20
4
2
B or N
15
2
3
1
1