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:
[TABLE="width: 125"]
<tbody>[TR]
[TD]Categories[/TD]
[/TR]
[TR]
[TD]Fruits[/TD]
[/TR]
[TR]
[TD]Veggies
[/TD]
[/TR]
[TR]
[TD]Meat[/TD]
[/TR]
</tbody>[/TABLE]
Then I have the destination table on Sheet 2 that has the categories from the source table in its first column:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Categories[/TD]
[TD]Day 1[/TD]
[TD]Day 2[/TD]
[TD]Day 3[/TD]
[TD]Day 4[/TD]
[TD]Day 5[/TD]
[/TR]
[TR]
[TD]Fruits[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Veggies[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Meat
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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!
[TABLE="width: 125"]
<tbody>[TR]
[TD]Categories[/TD]
[/TR]
[TR]
[TD]Fruits[/TD]
[/TR]
[TR]
[TD]Veggies
[/TD]
[/TR]
[TR]
[TD]Meat[/TD]
[/TR]
</tbody>[/TABLE]
Then I have the destination table on Sheet 2 that has the categories from the source table in its first column:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Categories[/TD]
[TD]Day 1[/TD]
[TD]Day 2[/TD]
[TD]Day 3[/TD]
[TD]Day 4[/TD]
[TD]Day 5[/TD]
[/TR]
[TR]
[TD]Fruits[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Veggies[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Meat
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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!