fill in blank cells after Grouping Subtotal

Originally Posted by JBeaucaire

1) Select the full range of cells with blanks
2) Press F5 and click on Special
3) Select Blanks and click on OK
4) Press the equal key: =
5) Press the Up Arrow once
6) Press CTRL-ENTER

You have the values but they are formulas. To remove the formulas
7) Select the full range again
8) Press CTRL-C to copy
9) Select Edit > Paste Special > Values

thank you but when I push the arrow up key it puts the cell above the first cell ie c25 into all of the blank cells not the cell relative to the each blank cell. Is there a way to do that?
Thanks
Stan