Fill Down
 

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

Fill Down
 

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


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=542449