Copying Data to Blank cells abovbe data in same Column

[SAMCRO2014]

I am trying to copy and paste data in column A to the blank cells above it.

For example: Cell A5 contains "1203" and I want it copied to the blank cells above A1:4
Cell A12 contains "1237" and I want it copied to the blank cells above A6:11
Cell A18 contains "1291" and I want it copied to the blank cells above A13:17

These cell reference are variable and will change depending on the data in the report. I know I need to do this with a loop (I think) but I am confusing myself trying to figure it out.

Any suggestions?

 

[Fluff]

If A1:A4 are genuinely blank & A5 has 120140100
I don't see how you could end up with everything as 0

 

[SAMCRO2014]

I just realized why it wasn't working. I had my Calculation set to Manual to speed up the macro. I changed it and voila! It works. Thank you both for your patience.

 

[MARK858]

You're welcome, your thanks go to Fluff as that post was where the work was done.