Are we talking about a specific column or do you mean for every cell on the
sheet?

How do you determine when to stop? I mean, if the last filled row in Column
A is, say, 1000, then 1001 is blank... do you want A1000 copied into it? If
so, then what about A1002... it is blank... should the newly copied data in
A1001 be copied into it? If so, this process would contiue to the end of the
sheet. So, how do you determine when to stop?

Rick

"ambr711" wrote in message
...
I want Excel to determine if a cell is blank, if yes then copy the cell
above, if no then move to the next cell until another blank cell is found
and
then copy the cell directly above