Fill in missing cells with copy of data from above

[ellbeardo]

Hi all,

I am wondering if anyone knows a quick way of filling in cells beneath data in the same column with the data that precedes it? & If there is a way to do this.

I have an example workbook attached, showing both the problem & how I'd want it to result in the solved tab.

I have thousands of empty cells that needs filling in so doing it manually isn't an option.

Thanks for any advice

[AliGW]

This can't be done in situ will a formula. It can be done to the side, or you could use VBA to do it in place.

In E2 copied across and down:

=IF(A2="",E1,A2)

[ellbeardo]

Brilliant. Thanks for that!!

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.