Hi there,
I have a large Power Query model which is made up of 5 sectors. The business want to split these into 5 workbooks for privacy reasons. Id like to run a macro that would filter the field 'sector' in power query by looping through the 5 sectors and then saving a sector version file. Question is.. how can I filter a field in Power Query using VBA?
I have searched the internet far and wide to an answer to this but to no avail so any help would be great. Im comfortable with loops so just need the code to write to the filter in Power Query.
Thank you in advance for your support!
Richard
I have a large Power Query model which is made up of 5 sectors. The business want to split these into 5 workbooks for privacy reasons. Id like to run a macro that would filter the field 'sector' in power query by looping through the 5 sectors and then saving a sector version file. Question is.. how can I filter a field in Power Query using VBA?
I have searched the internet far and wide to an answer to this but to no avail so any help would be great. Im comfortable with loops so just need the code to write to the filter in Power Query.
Thank you in advance for your support!
Richard
