Subtotal
 

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.

Subtotal
 

Select the column then try one of these:

Toolsoptionsgeneral: R1C1 reference style then edit replace blank with
"r[1]c"

or... press F5SpecialBlanks and type = then press down arrow then enter

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

"Nikki" wrote:

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.

Subtotal
 

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

"Nikki" wrote:

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.

Subtotal
 

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

"Nikki" wrote in message
...
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.