Forum Discussion

Copper Contributor

Nov 22, 2017

Adding Filtered Data From Another Spreadsheet

Is there a way to filter data in a spread sheet and then add it to another spread sheet, aside from copying and pasting? I imported data from another spread sheet, but I need to filter it and add par...

excel

office 365

SergeiBaklan

Diamond Contributor

Nov 22, 2017

Hi Tyrell

Advanced Filter https://support.office.com/en-us/article/Filter-by-using-advanced-criteria-4c9222fe-8529-4cd7-a898-3f16abdff32b could work, it filters data and copy result to another location

Tyrell Williams

Copper Contributor

Nov 22, 2017

Thanks, It works to an extent. It doesn't seem like the filter is continuous. Meaning if I add too or refresh the data I imported so that there are more items the match my criteria, it doesn't add to what has been copied. Do you know any way around that?

SergeiBaklan
Diamond Contributor
Nov 23, 2017
Hi Tyrell,

To my knowledge advance filter doesn't work with dynamic range (you may use static range with the gap for all possible data) and not auto-refresh. If only not to use VBA, you may google samples for such scenarios.

On the other hand you may use Power Query to pick-up your data, transform the data and load the result into another place. Better in combination with excel tables for raw data. If you import data from the external source perhaps you may combine importing and transformation of the data using suitable Power Query connector.