Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rows with formulas | Excel Worksheet Functions | |||
How to have formulas and formats auto copy to new inserted rows | Excel Discussion (Misc queries) | |||
Insert rows, keep a formula? | Excel Worksheet Functions | |||
INSERT ROWS WITHOUT SCREWING-UP FORMULAS! | Excel Worksheet Functions | |||
Inserting Multiple Rows with Formulas | Excel Worksheet Functions |