Never did any extensive work in Excel. I was a Lotus pro for years. I need help with the following:

I want to check a cell to see if it's empty. If it is I want to get the cell content of say, C31, and place it in the current cell. If it already contains data I want to move DOWN one and recheck until I get to the next empty cell to populate.

I know this is wrong but my thinking is

IF(ActiveCell="",=C31,DOWN)

But I'm thinking FOR loop will work better.

Additionally I need to know if it's better to do a VB script or a simple macro.

Thanx,
HH