Good afternoon -
I have a tab (Tab 1) that I use to track headings for annual financial statements and another tab(Tab 2) that tracks headings for interim financial statements. I want to be able to have Tab 2 always match what has been changed in Tab 2. So for example of I want what has been updated either by adding rows or deleting rows in Tab 1 to update Tab 2, how do I do this without having to go in an update formulas constantly when changes are made in Tab 1.
I have a tab (Tab 1) that I use to track headings for annual financial statements and another tab(Tab 2) that tracks headings for interim financial statements. I want to be able to have Tab 2 always match what has been changed in Tab 2. So for example of I want what has been updated either by adding rows or deleting rows in Tab 1 to update Tab 2, how do I do this without having to go in an update formulas constantly when changes are made in Tab 1.