New Example 2.xlsm

Had a good look at what you did and it works fantastically i think your a rock star. I can see why you chose to do it that way rather than in cell formulas.


Would it be possible to apply the same code to this new file? so that with data in right place looking like my Report sheet does now? i thought there might be a way to either create the format like i did in the vba creation part like it does when it labels cell "Clause" or somiething or it could be programmed to ignore the format i created and start the report below it rather than clearing each time button is pressed.

Additionally- where i placed compile report button could the VBA be adjusted to check for a tick box of some kind or a cell with a number or word in it to compile report based on that requirement?

For example if i wanted to compile full report of all sections then i "tick a box" for full or enter word full in a cell. summarily if i wanted to just compile 1 specific section i could tick section 7 box or enter 7 in a cell?

i was thinking i could have say 8 tick boxes labelled next to compile button that i could tick then compile to perform that function or perhaps one cell to enter FULL, or 1 or 7 for example then hit compile...

Again any help appreciated.

Regards
Dave.R