hi,
i would sort the names to force blanks to the bottom. Copy the names only to
sheet 2. I would then use the fill function to put the numbers next to each
name i.e. high light the column down to where you want the numbers.
EditFillSeriescolumnslinearstepvalue = 1ok.

Regards
FSt1


"Mike Pearson" wrote:

I have a column of names ie:

A
1 Bill
2 John
3
4 Mike
5 Rex
6 Stu

On another sheet, I want to have it list all the names on that list down a
column, but I want it to not carry over any blank cells. So on sheet2 it
would look like this:

A
1 Bill
2 John
3 Mike
4 Rex
5 Stu

Do you know how I can make that happen? Thank you in advance.