Autofill column blank cells: Fill the blank cell with the closest cell with a value above it.

[kevinlarey]

Hi!

I'm trying to figure out if there's a VBA or formula that I can autofill the blank cells in column B by taking the closest cell with a value above the blank cell and paste it.
When there is only one cell to fill, it's easy to use a formula but when there is multiple cells such as B13-B17, I can't find a way to paste TNT-4004 in all of those cells.

I don't want to manually double click the bottom right corner for each cell (TNT-4001, TNT-4002, TNT-4003, TNT-4004) since I have to do this for 100,000+ lines.

I'm really hoping there is a solution for this!

Thank you!

 

[Noxqss38242]

If cell is truly blank (which if cell has a space in it, it won't pick up a true blank)
On the home tab, on the far right should have "Find & Select"
"Go to Special"
Select "Blanks"
Click ok
All the blanks are now highlighted on the sheet
Go to the formula bar
Enter =
Then click on the cell above the blank with data in it
Then hold down Control button and hit enter.

 

[Fluff]

Hi & welcome to MrExcel.
Have a look here

3 Ways to Fill Down Blank Cells in Excel - Excel Campus

If you have blank cells in your data and you want to copy down the values above them, fill down using a macro, formula, or Power Query.

www.excelcampus.com

 

[kevinlarey]

If cell is truly blank (which if cell has a space in it, it won't pick up a true blank)
On the home tab, on the far right should have "Find & Select"
"Go to Special"
Select "Blanks"
Click ok
All the blanks are now highlighted on the sheet
Go to the formula bar
Enter =
Then click on the cell above the blank with data in it
Then hold down Control button and hit enter.

Hi Noxqss38242:

Wow! Thank you so much!

Such a simple solution but I was able to save a couple hours!

Thank you!