• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Risk Heat Map

yinky90

New Member
Hello All,

I would appreciate the help on Risk Register I am developing. I am trying to automatically capture the Risk IDs in their corresponding cells in the Heat map. Currently, I am doing it manually and it is very painful. I would appreciate the help.

I attached 2 files:

My File: Risk Register Draft: The columns of my interest are A,D,F,I
Staff Memeber file Hui, he posted a file in responses to a project but i am having hard time to apply his method
 

Attachments

  • Risk register Draft.xlsm
    64.1 KB · Views: 6
  • Modified Risk Map Faseeh-Hui.xlsm
    20.8 KB · Views: 8
Back
Top