Greetings,
I'm using ms excel 2007 in a Windows environment. Does anyone know of a technique or macro that can number a blank column based on blank rows? What I need, is stating in column "a" cell "a2"(which is blank) to number each cell down with the number 1 until it reaches a blank row then skip the blank and start with number 2 until it reaches a blank column and continue with 3,4 5 etc and stop when it identifies 2 consectutive blank rows. Any help would be greatly appreciated.
Best Regards,
Devera
I'm using ms excel 2007 in a Windows environment. Does anyone know of a technique or macro that can number a blank column based on blank rows? What I need, is stating in column "a" cell "a2"(which is blank) to number each cell down with the number 1 until it reaches a blank row then skip the blank and start with number 2 until it reaches a blank column and continue with 3,4 5 etc and stop when it identifies 2 consectutive blank rows. Any help would be greatly appreciated.
Best Regards,
Devera