Excel vba to renumber

[BORUCH]

hi i have the following sheet

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

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.