Hey All,
So I have an interesting challenge here (worksheet is attached). I'd like to write a macro that looks at Table 1, and based off of a cell value in a given row in that table, add certain values to a different table from that row. This macro should be activated by a button.
The example worksheet attached is an example of how the worksheet should look after the macro has been executed. My actual data has a couple thousand rows, and would need this functionality a couple of times per week.
But based off of my example sheet macro should:
- Look at System column in the top table
- For risks associated with system 1, copy the Unique ID, Probability, and Consequences to a new row in the System 1 table
- For risks associated with system 2, copy the Unique ID, Probability, and Consequence to a new row in the System 2 table
Thanks everyone!
Best,
Chris
Bookmarks