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 :)