More info  please:

"if a current cell  has data  in it"

Does this mean the cell is blank or has data or might it have a formula  in it
instead of data?

"copy the formula from the cell as it activates the next row"

where are you getting the formula from? The cell with no data? Or some other
cell?
do you want to copy  anything from other cells to the next row? or just select
the cell?