Copy last cell before a empty cell and paste (same column)

[fokeiro]

hi guys i need a macro or maybe if there is a way in excel, if i have a column like below and I'm trying to fill the blank spaces with whatever value is on the cell above. Not sure where to start on this. thanks for any help

Colum A
1
--- macro should put a 1
1
2
2
2

--- macro should put a 2​

2
3

--- macro should put a 3​

3

 

[Joe4]

There is a quick easy way to do it without macros.
See: https://www.excelarticles.com/excelbook/fill_blanks_with_value_above.html

 

[fokeiro]

There is a quick easy way to do it without macros.
See: https://www.excelarticles.com/excelbook/fill_blanks_with_value_above.html

easier than I thought thanks

 

[Joe4]

You are welcome.