Hi,

How can I fill below cells which are blank (Empty Cells) with the above cell data? Like in the following example:

Column: A
Cell 1: 54001
Cell 2:
Cell 3: 54003
Cell 4:
Cell 5:
Cell 6:
Cell 7: 56321
Cell 8:
Cell 9:
-------------------------The reuslt should be like the following in RED:
Cell 1: 54001
Cell 2: 54001
Cell 3: 54003
Cell 4: 54003
Cell 5: 54003
Cell 6: 54003
Cell 7: 56321
Cell 8: 56321
Cell 9: 56321


Please help me with function/code. Because I need to modify hundreds of records on several sheets. It is very hard to do it manually.


Thanks.