Good day to you all,
I am trying to revamp an old sheet (attached), this is what I am trying to do, and whilst I can do some of the things I need, there are a few I can not. My level of VBA is basic, and I can work out how to do a some of what I need. In the current version I have 30 odd sheets and formulas to do what I need, it is just not dynamic enough so that a user can add another X number of sheets without me spending ages re hashing all the formulas but it is clunky.
What I need is:
1. The user to be able to click a button and add x number of sheets, which the code will then unhide the "master" sheet and copy to the new one(s) then re-hide the sheet. Some of the cells are locked to prevent people changing, but this would just require some basic code to lock the sheet etc after it has been copied.
2. The user will then add details to the relevant cells where it will total down the bottom using the formula, or is it easier to make VBA do the totals in the background or store them in an array for later use (point 3).
3. These totals then need to go onto the "site totals" sheet on the next blank line. details such as the block name, concatenated with the lvl followed by the totals, I am finding it difficult to do this as there is a couple of blank cells between each total.
I would love some input on where to start, or even some ideas of what sort of code I will need so I can continue my learning curve :).
Thanks in advance for anyone willing to assist me