Fill Down

[Fuad]

Hi,

I have series of rows with the SUBTOTAL() function at the end and followed
by blank row seperating the product categories. I want to fill the formulae
down without deleting Subtotal() function and avoiding the blank rows to be
filled in. Can anyone help?

Regards,
Fuad

[mrice]

You could use a macro to insert the formulae using a loop that checked for the presence of blank lines or existing formulae.