Forum Discussion
Adding Filtered Data From Another Spreadsheet
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
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?
- SergeiBaklanNov 23, 2017Diamond Contributor
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.