Hi All,
I am working of service reporting will be sending report often where i use repetitive tasks like filtering excel sheet and sending the reports . i would like to know we can automate this task using macro only are any other method can be followed
Task i do daily
1- Filter data
2- Apply Formuale
3- Create Pivot Chart
4- Save As new file and deleting ,
its data which cannot be shared
I am working of service reporting will be sending report often where i use repetitive tasks like filtering excel sheet and sending the reports . i would like to know we can automate this task using macro only are any other method can be followed
Task i do daily
1- Filter data
2- Apply Formuale
3- Create Pivot Chart
4- Save As new file and deleting ,
its data which cannot be shared