Results 1 to 8 of 8

Hide & Unhide cells depending on drop down

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-16-2012
    Location
    Halifax, UK
    MS-Off Ver
    MS Office 365
    Posts
    206

    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
    Last edited by kieranm105; 10-05-2018 at 10:28 AM. Reason: Updated attachment

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hide and unhide rows and columns depending on value
    By ElliotH in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2016, 08:05 AM
  2. VBA to hide and unhide rows depending on a value placed in another cell
    By elleb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-27-2015, 04:43 AM
  3. Hide/Unhide cells based on drop-down list
    By Savvy25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2014, 02:36 AM
  4. Replies: 10
    Last Post: 09-17-2013, 10:36 AM
  5. [SOLVED] Hide/unhide cells depending on independent cell value
    By aaron061883 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-01-2013, 08:20 PM
  6. unhide cells depending on drop down box value
    By jmatthews in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2012, 06:28 AM
  7. Hide/Unhide Columns Depending on cell value
    By taghos7777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2009, 08:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1