Hi,
I am working a workbook I inherited from another user in the company. I want to create a dynamic copy of one table based on a unique set of one column. I created a new table pasted the unique values from the column I need in the new table and used index and match to populate the table data using a formula similar to.Please Login or Register to view this content.
This approach does populate the needed data, but there is significant lag time when trying to use any filters.
Is there a better way to create a copy of the original table based on a unique set of one of the columns or a better way to populate the data?
Bookmarks