Macro to create files from pivot data points

  • Hello Expert,


    I have raw data having many columns that is summarized in a pivot table similar to the one shown below. Now, I need to create a new files for each of the row label .


    Row Labels20012002Grand TotalJan22Feb1010Mar88Apr5954113May55



    Ex: The first file would be Jan_2001, that contains 2 records. Second will be Feb_2002 that contains 10 records.


    I have the pivot with 750 such data points, and hence need 750 files. PLease advice if I can automate this.


    Appreciate your guidance and support.


    Thanks.


    Regards,
    Alka

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!