Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 107
Default 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!

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert new row and copy formula bumiblumi Excel Worksheet Functions 1 December 2nd 09 08:12 PM
Insert Row - Copy Formula From The Row Above Phendrena Excel Discussion (Misc queries) 3 August 19th 08 07:18 PM
insert row and copy formula Andy B Excel Discussion (Misc queries) 4 May 29th 07 02:44 PM
Insert Row & Copy Formula redruthann Excel Worksheet Functions 0 March 26th 06 11:51 PM
Automatically insert row and copy formula Wendy Excel Worksheet Functions 5 August 25th 05 06:35 PM


All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"