Formula repeats only in one sheet

N

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
 
B

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?
 
N

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).
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top