autocopy in the empty cells

[lekhghimire]

I want to copy data from one cell to different other empty cells. Suppose C10 is empty, I want to copy data from A1. If C10 is not empty, the same data in C11 if it's empty and so on. Thanks for your help.

[rcm]

Please include an example of the before and after

[lekhghimire]

Please include an example of the before and after

Thanks
In fact, it is to copy data from a daily report. Suppose, I have data in p38, p39, p40. This data changes everyday. This data is to be copied on the daily basis in n43, n44, n45; o43,044,045; p43.p44,p45........ v43,v44,v45 and so on. If n43, n44, n45 already have data of the previous day, they should be copied in the next empty cells denoting the next day.
Thanks again.