| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically populating new rows with formuals above
Is there a way to do the following?
lets say there is a range spanning rows 1,2,3, with 3 columns A1 = B1 + C1 A2 = B2 + C2 A3 = B3 + C3 Lets say I enter a blank row at 2 A1 = B1 + C1 A3 = B3 + C3 A4 = B4 + C4 Is there a way to automatically fill in the formuals on row 2 so when I insert a blank row I get this: A1 = B1 + C1 A2 = B2 + C2 <the newly filled in formula A3 = B3 + C3 A4 = B4 + C4 The idea behind this is I'd prefer not to have to prefil lots of cells with formulas, and instead expand them as needed |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically populating new rows with formuals above
Instead of inserting a blank row, copy a row with the formula and insert
copied row. " wrote: Is there a way to do the following? lets say there is a range spanning rows 1,2,3, with 3 columns A1 = B1 + C1 A2 = B2 + C2 A3 = B3 + C3 Lets say I enter a blank row at 2 A1 = B1 + C1 A3 = B3 + C3 A4 = B4 + C4 Is there a way to automatically fill in the formuals on row 2 so when I insert a blank row I get this: A1 = B1 + C1 A2 = B2 + C2 <the newly filled in formula A3 = B3 + C3 A4 = B4 + C4 The idea behind this is I'd prefer not to have to prefil lots of cells with formulas, and instead expand them as needed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically Populating a Worksheet | Excel Worksheet Functions | |||
| Automatically populating fields in excel | Excel Worksheet Functions | |||
| Automatically populating a future date and time | Excel Discussion (Misc queries) | |||
| Help Automatically Populating A Summary sheet | New Users to Excel | |||
| Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) | |||
Hybrid Mode
