I am trying to figure out if there is a way to update table row categories when a list on a different sheet is updated. For example, on Sheet 1 I have the source table like the following:
<tbody>
</tbody>
Then I have the destination table on Sheet 2 that has the categories from the source table in its first column:
<tbody>
</tbody>
Now what I want to do is update the rows in the destination table whenever I add or remove rows from the source table. For example if I insert a row on the source table between Veggies and Meat and type in Bread, I would want it to also appear between Veggies and Meat on the destination table.
I have tried creating a macro button that will automate this but I am having trouble and it is becoming much more complicated than I imagine it should be.
Thanks for any help!
Categories |
Fruits |
Veggies |
Meat |
<tbody>
</tbody>
Then I have the destination table on Sheet 2 that has the categories from the source table in its first column:
Categories | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 |
Fruits | |||||
Veggies | |||||
Meat | |||||
Total |
<tbody>
</tbody>
Now what I want to do is update the rows in the destination table whenever I add or remove rows from the source table. For example if I insert a row on the source table between Veggies and Meat and type in Bread, I would want it to also appear between Veggies and Meat on the destination table.
I have tried creating a macro button that will automate this but I am having trouble and it is becoming much more complicated than I imagine it should be.
Thanks for any help!