Subtotal

[Nikki]

Can anyone tell me if there is a macro that will fill all blank cells in the
subtotal line based on the information above the subtotal line?

I need to get the blank cells to include the information in the cell above
the subtotal line because I will be sending files out to Sales folks. Pivots
will not work because I think they will not be able to work with it. The end
result is to subtotal but my challenge is that I will need to add details on
the subtotal line - right now all is gives me is the total lines which is
what it's suppose to do. If anyone can help me that would be great.

Something like: fill every blank cell within the region with the contents of
the cell above

Thanks so much.

 

[Lori]

Select the column then try one of these:

Tools>options>general: R1C1 reference style then edit replace blank with
"r[1]c"

or... press F5>Special>Blanks and type = then press down arrow then enter

Restore settings and copy and paste special values after to remove formulas.

 

[Lori]

Sorry there was a typo, replacement should be: "=r[1]c"

 

[Pete_UK]

If you press F5 (GoTo) and then click Special you will be presented with a
series of options - click on Current Region. Then press F5 again, Special,
and now click Blanks - only the blanks will be highlighted.

(The following bit isn't really needed, but it might help you to identify
what you have done later on - click on the Foreground colour icon, and
choose something like Blue. You might also want to set a background colour
to pale yellow, for example).

Begin to enter a formula by typing =, then use the mouse to click on the
cell immediately above the active cell, and then do CTRL-Enter.

This should give you what you asked for, and it will be nicely colour-coded
so that you can see where the subtotal rows are.

Hope this helps.

Pete