I am trying to create an macro that will evaluate text in a column B for eg.
If any text data exist in B1 make the count 1 and put the count number in
column A. If text data exist in B2 make the count 2 and and so on. If for
example B4 does not have text, I want the macro to skip to row B5 and
continue the count. The number of rows varies so I want to stop counting when
it reaches the last row of the file. Data is always in column C is until the
very last row.