Hey guys,

I am trying to automatically number variable rows in an Excel Sheet. For example I have my resources sorted by Organization and then Project Series, but I want to number only the resources themselves and not the Organization or Project Series Name.

I realize I will need to add the code to the existing resources, but it would help me out a lot if someone could give me some code so I don't have to add re-number my 500-something resource list every time I add a new resource!



Sample Spreadsheet

Organization A
Project Series A
1.Resource -stuff
2.Resource -other stuff
Project Series B
3. Resource -interesting stuff
[INDENT]Organization B
Project Series A
4.Resource -cool stuff
5.Resource -more stuff[
/INDENT]