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,


Beceriler: Veri İşleme, Excel, Excel Macros, Excel VBA, Visual Basic

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Barcelona, Spain

Proje NO: #19340490



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

%selectedBids___i_period_sub_7% gün içinde 70%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(3 Değerlendirme)

Bu iş için 26 freelancer ortalamada €158 teklif veriyor


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. Daha Fazla

€220 EUR in 3 gün içinde
(328 Değerlendirme)

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 Daha Fazla

€200 EUR in 7 gün içinde
(224 Değerlendirme)

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 Daha Fazla

€150 EUR in 3 gün içinde
(83 Değerlendirme)

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

€250 EUR in 3 gün içinde
(83 Değerlendirme)

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 Daha Fazla

€200 EUR in 5 gün içinde
(78 Değerlendirme)

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 gün içinde
(98 Değerlendirme)

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 Daha Fazla

€125 EUR in 3 gün içinde
(47 Değerlendirme)

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 Daha Fazla

€190 EUR in 3 gün içinde
(72 Değerlendirme)

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 gün içinde
(19 Değerlendirme)

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 Daha Fazla

€148 EUR in 2 gün içinde
(22 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(20 Değerlendirme)

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 gün içinde
(2 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(1 Yorum)

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 Daha Fazla

€155 EUR in 3 gün içinde
(1 Yorum)

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 Daha Fazla

€166 EUR in 3 gün içinde
(1 Yorum)
€155 EUR in 3 gün içinde
(0 Değerlendirme)

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 Daha Fazla

€155 EUR in 3 gün içinde
(0 Değerlendirme)

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 Daha Fazla

€133 EUR in 4 gün içinde
(0 Değerlendirme)
€244 EUR in 2 gün içinde
(0 Değerlendirme)

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 Daha Fazla

€277 EUR in 2 gün içinde
(0 Değerlendirme)