I have a large table which is frequently filtered and also has hidden columns. I have 2 problems:
- Every day I add data between the header row and the first row of my table. The table will not let me just copy Row 1 into the new row I insert; I have to first unfilter the table, then insert a new row and then copy row 1 into the new row.
- Also, I have many charts referring to this very large table (my boss is always constantly filtering these charts). Every day, when I add my new table row I have to edit the Horizontal Axis on all of my charts to include the new row I added. Not only is this very time consuming, if my boss has changed the filter since the day before I have to unfilter everything to ensure I have updated all the Horizonal Axis. The really stupid things is, it used to auto update, but for some reason, it no longer does.
Many thanks in advance if someone is able to help me.