Hi ,
Am generating the report for one company which is located in five areas. For Example , am having one field name called" Company"
In that am having so many field values but only four field values belongs to same company which is located in different places like Health care Delhi, Health Care Mumbai, HealthCare UP.
Now I have written macros exporting charts to excel but the thing is i want to generate one summary report for all the three locations which should be in first sheet. And other three locations i want to generate the report in seperate sheet like
1. First sheet should be summary of all the locations ( three locations)
2. HealthCare Delhi data should be in second sheet.
3. HealthCare Mumbai should be in third sheet likewise.
How to write the syntax in macro to export when we click on button all should export with corresponding data.
Anyone suggest me?
Thanks,
Nisha.
