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

Re: Macro to create files from pivot data points

PLease find the attached sample sheet, containing raw data and pivot table