pivot table data item

  • Thread starter Thread starter Dominique Feteau
  • Start date Start date
D

Dominique Feteau

Is there some code out there that will change the values the data area will
show? For example, the data area is in the column area and includes dec-04
to dec-05. Is there some code that I can use that will only choose one of
those months?
 
That other one didnt work Frank. I think this way may be a little better.
Just not sure on how to do it.
 
Hi
then you may explain what exactly dow not work. Mqaybe just a small thing in
the ranges used (as it worked for me :-)
 
I'm not sure. but i figured out another way (cheap way) of getting the info
i want into those cells. I just created a small macro that will copy and
paste a defined name from the second sheet to the first sheet via message
box. It does what I need so i'll jus leave it at that.

thanks a ton tho frank

niq
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
Wanted to show 12 month Date in Pivot table 2
pivot table 1
How I can set dynamic pivot table ONLY when I have enough data point 1
How do I force a pivot column if there is no data? 5
Change Pivot Table Filter Based on Cell Value 0
Converting CSV text 2
Pivot Table with Data Model Connection - getpivotdata #REF error 0

Back
Top