insert row and copy formula
 

problem:
user inserts a row into an existing table,
the insertion does not copy the formula from the row above (and below)

the integrity of the table is gone


HELP !!!

thanks in advance,
mark

insert row and copy formula
 

'HELP' might be a bit vague for this one!

If you want to stop the user from inserting rows, protect the sheet
with a password.

If you want them to copy formulas correctly, train them!

insert row and copy formula
 

copy formulas... thank you
(and I hate to say it, but some folks (esp. upper management, and owners)
are NOT trainable...

....there's got to be a way?
isn't there some sort of on insert event code that I could use to trigger a
code line to copy from ... to the target row?

"JakeyC" wrote in message
oups.com...
'HELP' might be a bit vague for this one!

If you want to stop the user from inserting rows, protect the sheet
with a password.

If you want them to copy formulas correctly, train them!