configure document to copy columns and rows based on a cell value

[salterian1974]

hi

long post and big request because i have hit a brick wall and maybe what i want is not possible but if anyone can answer its you peeps

i am working on a excel to create a checklist and each of the activities has a percentage attached to build up an overall progress

but some pieces of equipment to be checked will have multiple versions so i need to copy a number of cells based on a cell value IE i have 7 of these on a project so i need these rows times 7

when you enter a cell amount and hit the configure button it looks how many ZCA rows there are and either add or delete them and then renumber ZCA1 ,ZCA2 etc

then i need the % in the red cells update so what is in there now is split by the amount of ZCA'a there are

after that i need to modify the Export sheet to include the extra ZCA's

then once all this is done modify the values to print area to include all the extra rows/columns created

i know its a big ask and may not even be possible ive learnt so much from this site and your excel wizards so im hoping you can help

file i have so far is also linked below so you can laugh at my pitiful attempts at VBA

controls commissioning checklist V1.2.xlsm | Powered by Box

app.box.com