By Calpa on Tuesday, 13 October 2020
Posted in Excel
Replies 0
Likes 0
Views 3.7K
Votes 0
Hi, Is there a way to create a dynamic sheet that updates data from a specific folder with specific set of filters, that I otherwise always manuelly import with the Get data > from folder function in excel? I always need to "Transform data" the data and clicking the "Combine" filter at the first "Source" column to make all CSV files show all rows from all sheets in that folder. Then I also add some filters to another specific column to reduce the rows in total. Thanks for any advice about this!
View Full Post