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) Thanks Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting rows based on a cell value | Excel Worksheet Functions | |||
Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
Insert a number of rows based on a value in a cell on active row | Excel Worksheet Functions | |||
Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions |