master data services

  1. P

    Updating existing data from new worksheet by replacing only corresponding values

    Dear All, I have a Master sheet where I use to show the overall project progress. I get updates from my Contractors on a weekly basis. Both the sheets are of same formats and fields. The master sheet acts as a repository of all data (Numbers and dates). I want the Contractor sheets to feed the...
  2. J

    Using Macro to control Master Data Services functions

    Hi all, I have a workbook that has a Master Data Services connection which i use to maintain a list of items and their attributes - at the moment it's very manual and time consuming so I am looking to add some automation. In essence, changes to the list are emailed to me, I then collate them...

Some videos you may like

This Week's Hot Topics