I am trying to write a macro that will copy data from, lets say cell c3 and
paste it to cell c6. Each day I will be adding new data to cell c3 and
coping to the next blank cell c7, c8, c9, c10 etc.

The macro is more complicated than this and I can do everything I need to
except to add the data to the next blank cell.

Thanks for the help