Good Morning All,
My name is John. I am attempting to automate a reports process for my business. I run a report everyday that includes the call volume from three different companies, as well as the lost calls, hold time and talk time for each. I have had to manually copy and past these into a master sheet that then is linked to a larger sheet used by other departments for tracking purposes. I would like to be able to save all of these reports into the same folder.
I save the reports as a CSV file so that it can be opened in Excel. I would like to be able to save the report into the same file everyday and have it update on a the master spreadsheet automatically. Each report maintains the same formatting.
Any help you could provide would be unbelievable
Thanks!
My name is John. I am attempting to automate a reports process for my business. I run a report everyday that includes the call volume from three different companies, as well as the lost calls, hold time and talk time for each. I have had to manually copy and past these into a master sheet that then is linked to a larger sheet used by other departments for tracking purposes. I would like to be able to save all of these reports into the same folder.
I save the reports as a CSV file so that it can be opened in Excel. I would like to be able to save the report into the same file everyday and have it update on a the master spreadsheet automatically. Each report maintains the same formatting.
Any help you could provide would be unbelievable
Thanks!