| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Function - Adding new lines w/ formulas
I have created a database list (<Data <List <Create List) with 10
different columns. A couple of the columns have formulas in them that refer to cells in the same row - for example summing up the row total. When I add a new line, how do I get these formulas to copy into the new row? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List Function - Adding new lines w/ formulas
Arun wrote: I have created a database list (<Data <List <Create List) with 10 different columns. A couple of the columns have formulas in them that refer to cells in the same row - for example summing up the row total. When I add a new line, how do I get these formulas to copy into the new row? Is Tools|Options|Edit|"Extend data range formats and formulas" checked? Ken Johnson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List Function - Adding new lines w/ formulas
Yes, it is.
"Ken Johnson" wrote: Arun wrote: I have created a database list (<Data <List <Create List) with 10 different columns. A couple of the columns have formulas in them that refer to cells in the same row - for example summing up the row total. When I add a new line, how do I get these formulas to copy into the new row? Is Tools|Options|Edit|"Extend data range formats and formulas" checked? Ken Johnson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List Function - Adding new lines w/ formulas
Arun wrote: Yes, it is. "Ken Johnson" wrote: Do the formats/formulas exist in at least 3 of the 5 preceding rows? Help states this requirement, however, when I try it it seems to require that 4 of the 5 preceding rows have the formats/formulas. Ken Johnson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List Function - Adding new lines w/ formulas
I do now!! Beautiful. Thank you Ken.
"Ken Johnson" wrote: Arun wrote: Yes, it is. "Ken Johnson" wrote: Do the formats/formulas exist in at least 3 of the 5 preceding rows? Help states this requirement, however, when I try it it seems to require that 4 of the 5 preceding rows have the formats/formulas. Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generating a drop-down list from an IF function | New Users to Excel | |||
| Drop-down list compling with If function. | Excel Worksheet Functions | |||
| Function to select random values from a list. | Excel Worksheet Functions | |||
| Sub list and rum macros in the function | New Users to Excel | |||
| In Excel, can a function yield a drop-down list? | Excel Worksheet Functions | |||
Hybrid Mode
