Fill Down

G

Guest

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
 
M

mrice

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill down visible cells only 4
Conditional SUBTOTAL in XL210 Table 7
Series fill only copying and fill series greyed out 1
Auto-update Fill Series in column that has randomly spaced blank c 3
Drag formula - ignore blank cells 1
Data/Subtotal 1
Copy Cell From Subtotal Line To Detail Line 2
"Blank" cells showing unwanted data 4

Top