| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Value into cell automatically when new rows are created/inserted
The value in all cells in column D is as follows:
=IF($D6="","",RIGHT($D6,6)) However, if I insert a row anywhere, I have to copy to formula from above or below. Is there any coding I can do below to ensure that anytime a row is inserted that the formula is copied into the new D Column cell? Thanks in advance for your help, magmike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Row based on count and copy range to inserted rows | Excel Programming | |||
| Insert rows and keep merged cells in the inserted row | Excel Discussion (Misc queries) | |||
| Automatically copy formulas/functions to inserted rows. | Excel Worksheet Functions | |||
| automatically insert formula when new rows are inserted | Excel Worksheet Functions | |||
| Can inserted rows automatically include existing worksheet formula | Excel Discussion (Misc queries) | |||
![magmike[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
