Retrieving multiple data ranges in Essbase

[mcyang]

I think it's a simple question. Can someone help me with the VBA code? I have a tab for each month of the year: Jan, Feb, Mar.....

For each tab, I want to retrieve from a named range. Each of these ranges will be identical. For example A1:C20.

I'd like to be able to assign this macro to a button and push the button and then have all 12 tabs update instead of me going into each tab and updating it myself.

Additionally, I would like the macro to automatically replace #missing with 0.

Thanks for your help!

Michael

 

[dragon-goddess1990]

Hi

So is it a matter of (in manual terms) coping 1 named range to multiple sheets?

Amy