hi all
i have a data set that looks like below
i would like an excel vba that does this below
as you can see it moved over every group to the right
any suggestions is greatly appreciated
i have a data set that looks like below
Book1 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Item # | Description | qty | price | qty | price | qty | price | qty | price | ||
2 | 00000 | test 1 | 10 | $12.00 | 20 | $11.00 | 30 | $10.00 | ||||
3 | 00001 | test 2 | ||||||||||
4 | 00002 | test 3 | ||||||||||
5 | ||||||||||||
6 | 00004 | test 5 | 9 | $13.00 | 25 | $9.00 | ||||||
7 | 00005 | test 6 | ||||||||||
8 | 00006 | test 7 | ||||||||||
9 | ||||||||||||
10 | 00008 | test 9 | 10 | $14.00 | 20 | $15.66 | 30 | $14.00 | 40 | $13.00 | ||
Sheet1 |
i would like an excel vba that does this below
Book1 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
M | N | O | P | Q | R | S | T | U | V | W | X | |||
1 | Item # | Description | qty | price | qty | price | qty | price | qty | price | ||||
2 | 00000 | test 1 | 10 | $12.00 | 20 | $11.00 | 30 | $10.00 | ||||||
3 | 00001 | test 2 | ||||||||||||
4 | 00002 | test 3 | ||||||||||||
5 | ||||||||||||||
6 | 00004 | test 5 | 10 | $13.00 | 25 | $9.00 | ||||||||
7 | 00005 | test 6 | ||||||||||||
8 | 00006 | test 7 | ||||||||||||
9 | ||||||||||||||
10 | 00008 | test 9 | 10 | $14.00 | 20 | $15.66 | 30 | $14.00 | 40 | $13.00 | ||||
Sheet1 |
as you can see it moved over every group to the right
any suggestions is greatly appreciated