Subtotal

N

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.
 
L

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.
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top