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

salterian1974

New Member
Joined
Dec 16, 2019
Messages
7
Office Version
  1. 365
Platform
  1. Windows
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

1583745848929.png


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

1583745518243.png


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

1583746192378.png


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

 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,122,527
Messages
5,596,684
Members
414,086
Latest member
lionsenki

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top