I would need to automate the reporting that I have created manually and I would like assistance to do this.
Attached you can find the report (named [login to view URL]) that I created manually from a series of reports.
Also attached files called:
PO - Agent Ticket Activity
PO - Agent Ticket Activity (1)
PO - Agent Ticket Activity (2)
PO - Agent Ticket Activity (3)
These are for the daily activity for tickets, I can also get this file by week.
Another file attached is one called [login to view URL] that are the calls received weekly.
First issue is that the name of same people is not on the same format on the reports, for example: Bethan Price is Price, Bethan (100038) and so on.
The values that I am after are:
% of serviced calls
SUM Public + Private Comments
# Tickets Solved
Then I do a weekly ranking and then I do a year to date ranking.
If you need more information from my side please let me know but I would like to automate this via VBA or any other suggestion that you may have.
Thanks in advance,
I have been creating and running automated Excel reports with VBA for a number of years, and am more than capable of putting this together for you. In previous projects I have built scripts that grab data from the s Daha Fazla
Bu iş için 26 freelancer ortalamada €158 teklif veriyor
Hi, I can help you to automate your report. I can write a VBA script to import source data into master sheet and update the ranking for all people. Best regards, Florin Enache
hi, I have rich experience in excel and VB, and I do my best to save your time and pocket. I can help you with this. you need dynamic VBA to perform these tasks if you interested in more efficient results we would Daha Fazla
I have many experiences in ACCESS, Excel VBA developing and data mining. I'm software engineer and algorithm expert. Your task is suitable with me. I'm also perfected in C, C++, C#, SQL, PHP .... Thank you.
GO WITH SCIENCE AND EXPERIENCE. I'm a Master holder in computer science. FOR JUST 90 Euros and in JUST ONE DAY from awarding the project, it will be delivered to you in a HIGHER quality than expected. I'm an expert in Daha Fazla