save files using pivot

[Anil Khedgikar]

Hi ,
I am working on a Pivot table which has details based on project nos
eg
Prjct_code prjct_name employee_ name emp_code hrs_in_project
123 abc ddd 12 10
123 abc eee 13 40
there are several project codes I have a pivot based on the above details, I want to save details of each project code in a different excel file. Can you help me with the VBA code which will help me in asking location before saving and saving each file with project number in the same location (which I specify) from the pivot

Anil Khedgikar

 

[pakilprogramador]

hi, this is an example.

regards,