In Sheet3 of the attached there's an additional table (green) based on the data in Sheet1 converted to a proper Excel table. All you need to do is update the table on Sheet1 ensuring all the data is in included in that table, then go to Sheet3, right-click the table and chose Refresh to update it. No formulas, no VBA.
|