Hi All,

I have a subtotalled sheet, only subtotal rows are visible. I entered a
formula in the 1st subtotal row and I'd like to fill it down through subtotal
rows only. Is there a simple way (in Excel2007)? Dragging is not good because
it effects the hidden rows, too.

Thanks,
Stefi