LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
chris
 
Posts: n/a
Default how do I insert a row based on a function result

I want to run a a IF statement to qualify a row of data, and them if the
condition is true, I want to insert a blank row below the current row where
the fomula resides. I could also rework the formula to allow for the
insertion of the blank row to be above the current row, as well. Either would
work.

Any assistance would be great!
 
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
How to Insert function right on text values e.g. 0180001640 Gary Brown Excel Worksheet Functions 0 May 18th 05 05:26 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM
How do I insert a row when using an if function BP Excel Worksheet Functions 1 December 27th 04 05:15 PM
I need a function to update sales/expenses based on previous tota. Christine C Excel Worksheet Functions 2 December 20th 04 05:49 PM
Is there a formula to spell out a number in excel? Sha-nay-nay Excel Worksheet Functions 2 December 18th 04 09:25 PM


All times are GMT +1. The time now is 07:20 AM.

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

About Us

"It's about Microsoft Excel"