Inserting rows with Data, Formula's and Validation

D

Doug Manning

Hi all,

I posted this twice earlier today, but it hasn't appeared so if it triple
post please forgive!

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 in advance
Doug Manning
 

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
Add Rows based on Cell contents 0
Development combinations with exclusion of columns 0
Development combinations with exclusion of columns 0
Development combinations with exclusion of columns 0
Formula's won't read copy / pasted data ? 2
Skipping a cell and moving on to the next, with no blanks in betwe 8
Need cell formulas to return the day of every Monday in a month based on year entered 3

Top