How about just reformatting the numbers on the one sheet using a custom
format of

0.0,, "M"

Which will turn 1,500,000 into 1.5 M
--
HTH...

Jim Thomlinson


"JustBreathe" wrote:

Hi all,

I'm looking for suggestions on turning one of the schedules in my excel file
to millions. This schedule mainly feeds from a pivottable using the
getpivotdata function. I want the schedule to continue to be maintained in
whole dollars, however a few of my end users are interested in seeing the
same information presented in millions. My first thought is either a macro
that would quickly interchange the dollars between whole and millions, or
perhaps a mirrored schedule...I'd really perfer not to have to maintain two
schedules whent it comes to adding and deleting rows of data and such.

Thanks in a advance for any brainstorming you can throw at me :)