Formula Help - automatic move/insert of rows

[lmerson]

Hi! I have been trying to figure this out. I have a multiple colum
spreadsheet containing data, numbers and dates with 1 column containin
A=annual, S=Semi, Q=quarterly reviews.

I would like to write a formula for cell G3 (date of last review) tha
says "if D3=X (A,S,Q) (or this could be renamed as 3,6,12 mos) the
move and insert row 3, D3's X value from E3's date, and the
recalculate the date in Ixx as it falls into the new schedule.

Column I dates should always be chronological.

Am I asking too much? or can I do part of this in a formula?

I have attached a sample review spreadsheet.

Any/all help will be greatly appreciated! Thank you for your time!
:

Attachment filename: sample excel eval spreadsheet.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50464

 

[Frank Kabel]

Hi
not really sure what you're trying to do (inserting rows though is not
possbile with formulas). To check the value of D3 use something like
=IF(OR(D3="A",D3="S",D3="Q"),"do something,"")