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 |