Add Rows based on Cell contents

D

Doug Manning

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(CONCATENATE($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(CONCATENATE($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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert rows with Formulas 0
Inserting rows with Data, Formula's and Validation 0
Development combinations with exclusion of columns 0
League standings based off final scores 5
Development combinations with exclusion of columns 0
Development combinations with exclusion of columns 0
Need cell formulas to return the day of every Monday in a month based on year entered 3
Skipping a cell and moving on to the next, with no blanks in betwe 8

Top