Index Match slowing filters

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?

The attached file is a simplified version of the workbook in question. The first tab is the raw data. The purpose of the second tab is to bring only the unique locations based on the New ATM ID column. The third tab is intended to be the basis for exporting data to another workbook. The actual width for the first two tabs is 85 columns and the current data set is just over 1000 rows.

Sample File Uploaded

The errors were an oversight on my part. I neglected to replace the live data with the sample data. Please see the attached file.

I am guessing from the lack of response there are few suggestions for this issue.

Instead of using lots of live INDEX/MATCH formulas, perhaps what you need is a "Refresh" macro that will paste these as values, either on-demand e.g. by clicking a [Refresh] button, or via an event-trigger e.g. by activating that particular worksheet.

zeddy