Hi!
I have a sheet that looks like this: http://i.imgur.com/rQ0kq.png
And I need it to looks like this: http://i.imgur.com/Vg0BN.png
It is a very big sheet and basically there is no way to manually fill in the blank cells with the proceeding value. I need to be able to copy down the number (Cell: A1) into the blank cells (Cell: A2:A4) below it and then when the new number appears (Cell: A5) it needs to not override it but skip it and then copy it down until the next number appears.
I feel like this is hard to explain in words but the pictures above do a better job. Any help at all would be greatly appreciated!
Bookmarks