Updating Cost Center Dimension in BPC

Hi Experts,

Is there a way to update the members or properties in dimension thru a macro in excel where I just need to put the summary of changes in excel and click a button? How do you manage many updates from time to time during planning season especially? Below sample is Cost Center dimension but not part of the screenshot are other properties like, entity, function, cost center owner, etc.

Thanks,

Joseph