hi i have the following sheet
i would like for the vba to remove the numbers that are already there from my categories and renumber them as 1,2,3,
Thanks
GDGSGDGDS.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | ITEM # | MISC | DESCRIPTION | ||
2 | |||||
3 | 09 FRUITS | ||||
4 | |||||
5 | 00001 | APPLES | |||
6 | 00002 | BANANAS | |||
7 | 00003 | PEARS | |||
8 | 00004 | WATERMELON | |||
9 | |||||
10 | 1 VEGETABLE | ||||
11 | |||||
12 | 12345 | TOMATOES | |||
13 | 22222 | CUCUMBERS | |||
14 | |||||
15 | 65 SNACKS & CANDY | ||||
16 | |||||
17 | 1234 | SNACKS | |||
18 | J0001 | CANDY | |||
Sheet1 |
i would like for the vba to remove the numbers that are already there from my categories and renumber them as 1,2,3,
Thanks