Insert rows with Formulas
 

Hi all,

I have a spreadsheet that starting at row 18 contains the following
information
A18=M$2
B18= Datavalidation indirect ($M$2)
C18=IF(B18="No More
Options",VLOOKUP($B18,INDIRECT(CONCATENATE($M$2,"_ info")),1,FALSE),IF(B19<2,VLOOKUP($B18,INDIRECT(CO NCATENATE($M$2,"_info")),1,FALSE),CONCATENATE(B19, "
x ",VLOOKUP($B18,INDIRECT(CONCATENATE($M$2,"_info")) ,1,FALSE))))
E18=IF(ISERROR(VLOOKUP($B18,INDIRECT(CONCATENATE($ M$2,"_info")),2,FALSE)),"",VLOOKUP($B18,INDIRECT(C ONCATENATE($M$2,"_info")),2,FALSE)*B19)
G18=COUNTA(INDIRECT(A18))-1

Columns D and F are 0 Width because they contain information in other rows
that are not to be seen

What I want to do is if B18 does not equal specific text "No More Options"
it will insert two rows with the same formulas and datavalidation at row 20,
but set the value of B20 to "No More Options". then start the whole process
all over again starting at row 20 and inserting at row 22 if B20 does not
equal "No More options" continuing until the maximum amount has been reached
(cell G18).

Any help on this would be greatly appriciated.

Doug