Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
Re: Move cell data to another worksheet dependent on checkbox being ticked
You are a genius Carim!! :music:
I am still unsure what modifications are needed. I know I demonstrated this to the teams that will use it and they were super excited!!
Hopefully they will let me know and then I can ask you again. If you ever move to England please let me know and you can come and work with me!! 
You are the BEST!!
Re: Move cell data to another worksheet dependent on checkbox being ticked
Donna,
Thanks for the Music ....:dance:
Please find attached what you call the Combined version ... with added risks (in red...) ... :wink:
Hope your colleagues will be enjoying an "easier-to-use" worksheet ...
Cheers
P.S. Please note that ... Inserting Rows such as the Blank row 8 ... or any "Mark" row for a new risk ... will disrupt all the calculations ...
Re: Move cell data to another worksheet dependent on checkbox being ticked
Hi Carim,
That is fabulous!! I only have one very final question (I bet my questions are very frustrating!!)
How do I set the report so that if 8.1 (for example) on the Site Specific worksheet only shows point 8.1 on worksheet 8 (instead of 8.1 through to 8.3 for example)?
Re: Move cell data to another worksheet dependent on checkbox being ticked
Hello Donna,
Glad the "Combined" version is now operational ... :wink:
The question you are asking is very interesting ... and indeed it should be a requirement of yours ... (sadly, I did not think about it in the draft version...)
It does require some programming ... since, it is quite obvious, you would need this feature throughout the entire workbook .... 8-)
The trouble is that, I knew, right from the beginning, that your appetite for perfection could easily be ...infinite ...:wink:
Let me take a look ...
Re: Move cell data to another worksheet dependent on checkbox being ticked
Hello Donna,
In order to move forward ... there is a need for framing things ... and being consistent ...
Especially with the objective to hide automatically items not marked ...
All the "red" rows had strange hyperlinks ...
So all hyperlinks have been deleted ... and re-created to jump to the appropriate row ...
Another issue... for example, all Columns A have to in Text format ... and filled-in with the same logic ...
i.e. almost all Sheets have inputs on each row like 7.1a, 7.1b, 7.1c , etc ...which is OK .... but there are several exceptions like Sheets 3,6,10,12 ...
In addition, exceptions like row 6 in Sheet3 is empty ... guess you intended to double 3.1a which will cause problems ...
So, could you please review the attached version 2 ... in which a macro has corrected the majority of the inconsistencies ...
Keep in mind, for a program to be fully automatic ... rules have to be clearly identifiable ...
Cheers
Re: Move cell data to another worksheet dependent on checkbox being ticked
Hello Donna,
Have spotted and corrected a series of inconsistencies with blank rows, errors in numbering, risks items copied from another sheet, etc...
Therefore, could you kindly Validate all Risk sheets as well as the master one ...?
The attached "cleaned" version should become our starting point ...
Will only dive into the programming ... after getting your stamp ...
:smile:
Re: Move cell data to another worksheet dependent on checkbox being ticked
Hello Donna,
Attached is the Version 3 ... which includes the hiding of all Not-selected risks within their respective worksheets ... :wink:
Basically only Marked X Risks will remain visible ... once you have asked for "Prepare Report" ...
Obviously Reset will get you back to the initial situation ...
Hope this will help
:smile:
Re: Move cell data to another worksheet dependent on checkbox being ticked
Hello Donna,
Have you had a chance to take a look at the latest Version 3 ...??? :wink:
Do not hesitate to share your reactions ... :smile:
Re: Move cell data to another worksheet dependent on checkbox being ticked
Thanks for your message ... !!!
As soon as I have a moment, and for the pleasure to see you dancing ... :wink: ... I will look into the bugs for clauses 9.13 and 9.14 ...
By the way, you can add borders as much as you want .... BUT ... please NEVER use Merged cells ... !!! ... and use Center Across Columns :
To do this, follow these steps:
1. Select the range of cells over which you want to center text.
2. Right-click the selected cells, and then click Format Cells.
3. Click the Alignment tab.
4. In the Horizontal list, click Center Across Selection.
5. Click OK
Cheers
:smile:
Re: Move cell data to another worksheet dependent on checkbox being ticked
Hello Donna,
Just to confirm the two clauses 9.13 and 9.14 had their original numbering mixed up ...:?
Attached is the Version 4 with the required corrections for both items ... :wink:
Hope this will be in line with your expectations ...
Re: Move cell data to another worksheet dependent on checkbox being ticked
Hello Donna,
Version 4 is now posted on Page 4 ... :wink:
Have you had a chance to take a look at it ... ???
Re: Move cell data to another worksheet dependent on checkbox being ticked
Hello Donna,
It looks like there have been quite a number of downloads of Version 4 ... :wink:
Do not hesitate to share your comments ... once you have had a chance to take a look at it ...
Cheers
:smile:
Don’t have an account yet? Register yourself now and be a part of our community!
