looping through pivot tables

[sachinkapasi]

Hi,


I have a pivot table and the data in the pivot table looks as follows:


UID Date Start Act

68779 12/14/2012 500

12/15/2012 $(28)

12/18/2012 $(460)

12/28/2012 $(6)

2/11/2013 $(4)


The "Start" and "Act" are different occurrences of a column called Tran_Type which I have used as a column Label filtered to select the "start" and "act" values and the Values of the pivot field is an Amount


I want to do two things:


I want to get the uid and count of dates (I can do that in a separate pivot but was wondering how to get it in macro)


Second, I want to order the date and find the duration between oldest and newest activity


Please let me know

 

[sachinkapasi]

can someone please look at this..atleast if someone can read and say whether the question is clear or not

 

[NARAYANK991]

Hi Sachin ,


The first point to remember about code is that it helps if you upload your data , since any code has to be tested with data before the person who is writing is sure that there will be no problems. If you do not upload your data , then the coder has to generate the data , which is clearly time-consuming and unwanted work.


The easier you make it for others , the more they will be willing to help you.


Please upload your workbook , with some sample data , and hopefully you should get your solution.


Also , please remember that questions posted on weekdays are more likely to get immediate answers than questions posted over the weekend ; if you post a question on Friday night , please wait till Monday afternoon before putting in a reminder.


Narayan

 

[sachinkapasi]

Sorry new to the forum...will upload and wait