Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Doug
 
Posts: n/a
Default 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   Report Post  
Alan
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Alan
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
revert formula insertion to old method Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 02:49 PM
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 10:04 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 07:57 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 04:13 PM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 11:18 PM


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"