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.