To make the macros know about added rows

[Lana]

Hi Subj.
I have the subtotal of a few columns. How do I make this subtota
update if new rows have been added?

ThankS a lot

 

[Lana]

I'm desperate

 

[jeff]

Hi,

First, can you explain a bit more or show a snippet
of your code &/or spreadsheet layout to give us more
info? - I trust, since it's mentioned in the
subject line, that you have macro code summing data.

You'll probably have to either keep track of the
rows of data to subtotal, or assign beginning cells
to a range where your code can just refer to the range
to total.

jeff

 

[Dave Peterson]

I like to put the subtotals at the top.

Row 1 contains formulas like: =subtotal(3,B3:b9999)
row 2 contains headers for the columns.
Row 3 to 9999 contain (or may contain) the values.

If I apply Data|Filter|autofilter, I can see the results as soon as I filter,
too.

 

[Lana]

I've just made adding new rows regulated by button and protected shee
so that nobody can add anything other than using that button. Not th
best solution, but I was really short of time and it works ;-)))

Thanks a lot anyway, it's a great forum and the best place to see
help