insert rows that retain formulas of rows above

B

bruce gray

I have made a simple xls cash book that calculates gst,
and does split entries for various accounts.

Everytime I want to insert new data, I have to insert new
rows. These new rows don't adopt the formulas of the above
rows. is there a way to insert rows that adopt formulas of
the rows they are inserted between?

TIA
Bruce
 
A

Andy Brown

I have made a simple xls cash book that calculates gst,
and does split entries for various accounts.
Click to expand...

I don't know what most of that means.
Everytime I want to insert new data, I have to insert new
rows.
Click to expand...

Why - don't you just add them at end?
These new rows don't adopt the formulas of the above
rows. is there a way to insert rows that adopt formulas of
the rows they are inserted between?
Click to expand...

You could use code for this. Or you might be able to get by with Tools --
Options -- Edit -- Extend Formats & Formulas (although it will depend where
you're inserting ; you'll need 4-5 rows above already for Excel to get the
drift).

HTH,
Andy
 
A

AlfD

Hi!

If you are inserting, keep a fully formatted and formula'd spare row a
the end of the block you are inserting into.

When you want to add a row, copy this spare row and insert the cop
above the spare.

It's useful, too, if you want informal subtotals, because a manua
subtotal row at the bottom of such a block will then take on board th
new row.

Al
 
G

Guest

I don't know what most of that means.
Click to expand...


sorry, you probably wouldn't understand gst if you are
American. Much of the rest of the world uses it. It
is 'goods and services tax'. And is the only tax applied
to goods and services. Business operators are responsible
for collecting it by building it into their pricing
structure, then passing it onto the government. However,
the only people expected to pay GST are end consumers.
Therefore, all businesses buying goods and services in the
process of producing the same, can claim a rebate for GST
they pay for materials etc. This results in a lot of
pointless bookkeeping effort upstream from the end
consumer. However, the system is probably fairer than any
alternative.


Why - don't you just add them at end?
Click to expand...

Even when i add them at the end, the formulas aren't
intuitively applied by excel for every column, as each
column doesn't necessarily have an entry in previous
consecutive rows. Thus, "Extend Formats & Formulas"
doesn't suffice.

Thanks for the advice nevertheless.

Cheers
Bruce
Brisbane
Australia
 
A

Andy Brown

sorry, you probably wouldn't understand gst if you are
American.
Click to expand...

LOL! I'm in the UK.
Even when i add them at the end, the formulas aren't
intuitively applied by excel for every column, as each
column doesn't necessarily have an entry in previous
consecutive rows.
Click to expand...

OK. That wasn't made clear. Not to worry, Mr McGimpsey has now provided a
link to some code.

Rgds,
Andy
 
G

Guest

That's great. thanks for digging that up and taking the
time to pass it on.

Bruce Gray
Brisbane
Australia
 
Top