Home |
Search |
Today's Posts |
#1
|
|||
|
|||
insert a new row by formula
Is there a way to insert a new row based on the value in a cell of an
existing row? Thanks in advance for any help. |
#2
|
|||
|
|||
Not with a formula, only with VB code. A cell formula can only change the
value of another cell (or cells). It can be done, but you need to give more information of what you are trying to achieve, Regards, "Doug" wrote in message ... Is there a way to insert a new row based on the value in a cell of an existing row? Thanks in advance for any help. |
#3
|
|||
|
|||
I bet Alan meant to say that a formula can only return values to the cell(s)
containing the formula. Alan wrote: Not with a formula, only with VB code. A cell formula can only change the value of another cell (or cells). It can be done, but you need to give more information of what you are trying to achieve, Regards, "Doug" wrote in message ... Is there a way to insert a new row based on the value in a cell of an existing row? Thanks in advance for any help. -- Dave Peterson |
#4
|
|||
|
|||
I did indeed! Sorry,
Alan, "Dave Peterson" wrote in message ... I bet Alan meant to say that a formula can only return values to the cell(s) containing the formula. Alan wrote: Not with a formula, only with VB code. A cell formula can only change the value of another cell (or cells). It can be done, but you need to give more information of what you are trying to achieve, Regards, "Doug" wrote in message ... Is there a way to insert a new row based on the value in a cell of an existing row? Thanks in advance for any help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |