Add Values to New Tables Based on Cell Value in Table 1

[ChrisHook]

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

[jindon]

Try

Please Login or Register  to view this content.

[ChrisHook]

That's awesome!!! Any way I can just get the tables to update to an existing sheet instead of creating a new one for each update though?

[jindon]

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

replace SheetNameHere with sheet name that you want to output to.
[/code]

[ChrisHook]

Almost works. However, when you start to add or subtract more rows from table 1 it starts to return incorrect values from incorrect columns.

Is there any way to just run a loop through table 1 to look for the system name, and return the unique id, probability, and consequence from that row to a predetermined table (i.e. if i created a "System 1" table, then values from table 1 for System 1 would be returned to that table)?

[jindon]

Upload a file that you are talking about.