Formula repeats only in one sheet

[Naomi]

i am doing a really simple thing in excel but an having issues

i have 2 columns to add up

Nett $$ Tax $$ Gross $$
10.97 1.63 12.60
522.00 78.00 600.00
281.01 41.99 323.00
760.17 113.58 873.75
828.68 123.82 952.50
897.19 134.06 1031.25
884.14 132.11 1016.25
1442.00 301.65 1743.65
147.21 21.99 169.20
30.70 4.58 35.28
5804.07 953.41 6757.48


on one of my sheets when i insert a row i dont have to add in formula's it
does it all automatically

on another sheet if i insert a row i have to do the formulas again

nett and tax columns to be added with value in gross

then a total of the 3 at the bottom is what i am trying to achieve

any help is great

Thanks

Naomi

 

[Bob Phillips]

Naomi,

Hank Scorpio and I had an exchange recently on a similar topic. I was
getting formula auto extending, and he wasn't. There is an option in
Tools>Options Edit tab to set this facility, but as Hank says in the snippet
below, it can be particular about when it works,

The option doesn't exist in Excel 97; it looks like it was a new
addition in 2000:
http://support.microsoft.com/default.aspx?scid=kb;en-us;231002

I also have the checkbox checked in XP (like you, I've never touched
it before), but what I did find is that it tends to be very particular
about the circumstances under which it operates. If I follow the
example in KBA 231002 to the letter, it will work. Make a slight
change (like having a rand() formula generate some of the values in
columns A or B, or leaving column A empty), and it won't.

Does this cover your situation?

 

[Norman Harker]

Hi Naomi!

Re:
"not to forget Mr Harker"

Only magistrates call me "Mr", before transporting me for life to
Australia <vbg>.

We try to keep it friendly and non-confrontational here. There's
plenty of other newsgroups around if you want to get insulted and
flamed.

But thanks is always welcomed and you'll find over time that you'll
learn a lot by only watching and participating where you can share
your knowledge of how to use Excel for whatever you do with it.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 21st July: Belgium (National Day),
Bolivia (Martyrs’ Day), Guadeloupe (Victor Schoelcher Day), Guam
(Liberation Day), Japan (Marine Day), Malta (St. George Festa), Peru
(Feria Local Fronteriza Peruano Ecuatoriana), St. Martin (Schoelcher
Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.