Hide & Unhide cells depending on drop down

Hi
I have a Risk Assessment sheet within my RAMS workbook.
This has now to include a checklist of the risks that are present for the current job. Our H&S consultant company wants the sheet to be blank (i.e. no risks showing, just the first detail page and the last signing page) and then as each risk is ticked on the checklist the risks will appear on the next pages.
I previously had a series of combo tick boxes at the top of the page which hid the risk and inserted blank rows in its place, this worked ok'ish.

I have created the list on the first page with each risk having a drop down (hidden in col AC) box in the cell next it with the wingdings tick.
There is a second sheet which will be hidden with all the risks on in the correct order that they appear in the list.
I want this to copy and paste / insert each risk into the RA sheet starting at cell A42 and keep them neat.
This needs to work and keep them neatly underneath each other depending on what risks are put in (i.e. not just sequentially).

What is the best code to do this?

Kieran

I have changed the drop downs for activeX checkbox and done this code which works ok for the first one.

Please Login or Register  to view this content.

I have all my checkboxes in the workbook now and added page breaks in to get make sure its all on the page correctly.
they all use the following code with the relevant cells changed.

Please Login or Register  to view this content.

This works if I want all 35 risks and then the signing/total pages at the bottom.
But if one of the risk is taken out it will leave a blank rows, and likewise if you select different risks there will be blank rows.

What I would like it to do is look for the next blank cell (starting from A42 onwards) and then paste the data in from the 'Risks' sheet.
Any ideas / help?
Kieran

Hi kieranm105,
Lesson nr. 1 in VBA Avoid Select and activate, it slows down your code big time an it is rarely needed.
See this example:
This code

Please Login or Register  to view this content.

does exact the same as your code

Please Login or Register  to view this content.

Lesson nr 2 keep it simple
See your title: Hide & Unhide cells depending on drop down, why don't you use it instead of the slow copy paste stuff.
You don't need the page Risks,because the data is on your Ra page.
Application.ScreenUpdating = True is not necessary, this goes automaticly.
See attached.

Glad to help .
Have a nice day.

I need to have another look at this as it doesn't look good when printing out. There are gaps when I have the print area set and page breaks in.