VBA macro to create new workbook

[Avicric]

Hi All,

Need your help with VBA:-

I am attaching a sample worksheet for reference(please note I cannot attach the actual workbook as it contains confidential data).

what I need is a macro which will save the data for each of the item from the pivot filter in a new workbook and save the workbook with the name selected from the filter.

Thank you for your help

[Avicric]

Hi All,

Need your help with VBA:-

I am attaching a sample worksheet for reference(please note I cannot attach the actual workbook as it contains confidential data).

what I need is a macro which will save the data for each of the item from the pivot filter in a new workbook and save the workbook with the name selected from the filter.

Thank you for your help

Hi guys,

I have managed something as far I my basic knowledge with VBA....
hope someone out there can guide/help me further....

I am attaching an updated excel with the VBA code I could come up with.....
need help to get it working...
need to save each worksheet with the name in the pivot filter...

thanks in advance!!!

[maniacb]

Maybe this will work for you

Please Login or Register  to view this content.

[Avicric]

Maybe this will work for you

Please Login or Register  to view this content.

hello Maniacb.....
thanks a ton you just made my day

not exactly what I wanted but helped me figure it out, so I am glad....