Hey guys, this is my first post and I really hope someone will be able to help me. So here is a little background on my project. I am an environmental engineer doing different risk/health assessments on various sites. My excel (2007) file has 4 sheets. The first three are based on increasing health and safety risks uncovered at the sites (i.e green, amber and red).
Each sheet (1,2 and 3) contains 3 columns. A contains abbreviations for a certain risk, B has a description of that risk, and C is for a yes/no checklist if the health and safety risk described in that row applies to that site.
So what I need is that if I type 'y' in a cell from C (on any of the first 3 sheets), the corresponding description in cell B is transferred to Sheet 4.
Does this make sense? Please let me know if you need more detail or what I can do make this work.
Thanks in Advance!
Each sheet (1,2 and 3) contains 3 columns. A contains abbreviations for a certain risk, B has a description of that risk, and C is for a yes/no checklist if the health and safety risk described in that row applies to that site.
So what I need is that if I type 'y' in a cell from C (on any of the first 3 sheets), the corresponding description in cell B is transferred to Sheet 4.
Does this make sense? Please let me know if you need more detail or what I can do make this work.
Thanks in Advance!
