Add Rows based on Cell contents
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 |
All times are GMT +1. The time now is 11:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com