Hi,

A macro could do that in several ways but what do you want it to do as it
counts down the column?

Mike

I want column 1 cells to have sequential numbers if column 2 same
cells has data in it. If column 2 cell is blank I want column one same
cell blank.

Thank you for your help,
jfcby