Hello,

Subj: Filling-in data based on adjacent cells.

I am using Microsoft Excel 2000. Here's my (autofill?) question...
I have data in some rows, others are vacant; e.g.,
          Col 1       Col 2        Col 3
         
1        line two    line two    line two
2        line three line three line three
         empty
3        line five   line five     line five
         empty

My first question I suppose should be just how to number the lines within a
range.  Anyhoo, as you see, my question is not to number every line within a
range* but rather to number only those lines that
have data in the next column.

Thank you, -John
johnjesmer@yahoo.com

*I am aware "Edit, Fill, Series" will number every line.
This is not what I am looking for.  Can you help please?