Automating my reporting needs


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:

# Calls

% 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,


Skills: Data Processing, Excel, Excel Macros, Excel VBA, Visual Basic

See more: automated reporting python, vba report automation, how to automate reports in tableau, automated reports definition, reporting tools, best reporting dashboards, automate reporting process, automate report writing, breadth first search java code example, depth first search java code example, Needs to be high resolution 400 dpi At 100% ?? and the dimension are 600mm high by approx 5 meters wide, Write an iPhone application Hi,i have done unity3d project and i want to convert mac build in dmg build so if any one know how , We are a popular Tabletop Games company that needs a new logo design based on a provided mockup. The logo should be of a 1:1 asp, The goal should be to present a modern private practice - naturally in Responsive Design. Contents of the website remain the sam, mr x deposited a certain amount of money for a fixed period of time . on maturity he received a total of tk. 45000 when the rati, first class psychology essay example, india first dedicated scientific mission to study the outermost layer and the chromosphere of sun is, good first issue, first food blog post example, a reading from the first letter of st paul to the corinthians 12:31- 13:8

About the Employer:
( 0 reviews ) Barcelona, Spain

Project ID: #19340490

Awarded to:


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 More

€70 EUR in 5 days
(3 Reviews)

26 freelancers are bidding on average €158 for this job


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

€220 EUR in 3 days
(328 Reviews)

Hello Edson, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource t More

€200 EUR in 7 days
(224 Reviews)

This is Excel /VBA result which I 've done [login to view URL] This is what i have done in Excel/VBA/MACRO. Just Crreating forms, query, Macro, custom formula, etc... I;ve done so many jobs in excel like l More

€150 EUR in 3 days
(83 Reviews)

I am excel and vba expert, I can do it easily. lets discuss. Mohsan

€250 EUR in 3 days
(83 Reviews)

With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked t More

€200 EUR in 5 days
(78 Reviews)

I am an Excel expert. My specialization is creating complex formulas and macros. You may check some of my work here: [login to view URL]

€100 EUR in 2 days
(98 Reviews)

Hi, I am an excel VBA expert and studied through the various files attached. The functions you are after can be executed by use of different macros. I regularly make dashboards using VBA , the reviews of which you c More

€125 EUR in 3 days
(47 Reviews)

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple More

€190 EUR in 3 days
(72 Reviews)

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

€190 EUR in 4 days
(19 Reviews)

I have more than 5 years of experience in advanced excel, VBA automation, reporting automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I h More

€148 EUR in 2 days
(22 Reviews)

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 More

€100 EUR in 1 day
(20 Reviews)

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.

€155 EUR in 3 days
(2 Reviews)

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 More

€90 EUR in 1 day
(1 Review)

Hi Dear client! I have read your requirement and I am very interested in your project. Seems to be an interesting work and good opportunity to show my skills to work with you in future as well. I'm a professional More

€155 EUR in 3 days
(1 Review)

Hi, How are you today? I have just read your job description carefully and I am very interesting in your job. I am a senior Excel,VBA,C,C++ ,C# developer with 10 years experiences and I have developed many program of More

€166 EUR in 3 days
(1 Review)
€155 EUR in 3 days
(0 Reviews)

Hi, I will love to work on this project. I already have gone through the data what you have shared looks like i need some more information from you. Earlier also I have done this kind of work with full Accurac More

€155 EUR in 3 days
(0 Reviews)

I am a Selenium certified expert in test automation , which involves automating different web applications and excel data sheets. I have 8.5 years of coding experience and have successfully delivered a few projects re More

€133 EUR in 4 days
(0 Reviews)
€244 EUR in 2 days
(0 Reviews)

I’ve done every type of report and automation one can do with excel, vba, macros, etc. I’m more than willing to show you some of my complex videos of dashboards, reports and other jobs I’ve done. I’ve worked in finan More

€277 EUR in 2 days
(0 Reviews)