Excel Macros for Master Data Services

Kerry Potts 1 Reputation point

I have a number of Models and Entities Setup and have connected in Excel through Master Data Services (MDS).
There is data in other spreadsheets that I would like to filter, copy and publish to the MDS workbook.
Are there macros available to complete these tasks? I have only been able to complete the copy task.
I need to update a set Filter on the MDS sheets and then publish the data once it is copied through Macros in Excel, is this possible?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,612 questions
{count} votes