View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] desmarteau@gmail.com is offline
external usenet poster
 
Posts: 2
Default Numbering - Starting Over Based on Zero

I have a sheet that is like this:

A B C
content 0 Yes
content
content
content 0 Yes
content
content
content
content
content 0 Yes
content
content
content


What I want to do is number column b as 0,1,2,3,4,5 etc and start over
numbering when it hits a 0.

How would I do that with a macro....or is there an easier way.

Any help would be so appreciated.

Thanks,
Louise