Loop Through Blank Cells and Populate with Value Above

[marka87uk]

Hi,

I need to loop through the selected range (e.g. A8:E10000) and if a cell is blank then it's formula needs to equal the cell above it (i.e. if A10 is blank then it's formula should be =A9).

Please can you point me in the right direction?

Many thanks.

 

[Jonmo1]

Highlight the range A8:A10000
Press CTRL + G
Click Special
Select Blanks
Click OK
Press =
Press UP Arrow
Press CTRL + ENTER


If this must be done in a macro, use the macro recorder to record yourself doing the above steps.

Hope that helps.

 

[James006]

Hi,

Is there a specific need for a macro ?

F5 Special Blanks
equal above cell
control enter

HTH



P.S. oops ... JohnMo1 went a lot faster ...

 

[marka87uk]

Wow that's great, thanks. I didn't realise it could be done like that!

 

[Jonmo1]

Glad to help, thanks for the feedback

 

[patel45]

very good solution, but on my italian localized Excel I press Ctrl + D