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.



Participate now!

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