I have a table which (as tables do) automatically extends as new rows of data are added.
I'd like to create a duplicate of that table to a separate sheet (so that I can persistently filter it for charting) but I'd like the duplicate table to extend its range automatically as data in the original table is added with new rows.
Currently I have the duplicate table with each cell simply referencing its counterpart in the original table and that works for filtering purpose but the duplicate table will not reflect new data added in the original
Any ideas how to achieve this?
Bookmarks