Đã hoàn thành

Automating my reporting needs

Hi,

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,

Edson.

Kĩ năng: Xử lí dữ liệu, Excel, Excel Macros, Excel VBA, Visual Basic

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Barcelona, Spain

ID dự án: #19340490

Được trao cho:

danluckingdl

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 Thêm

€70 EUR trong 5 ngày
(3 Đánh Giá)
3.0

26 freelancer đang chào giá trung bình €158 cho công việc này

schoudhary1553

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. Thêm

€220 EUR trong 3 ngày
(328 Nhận xét)
7.9
elqueabandona

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 Thêm

€200 EUR trong 7 ngày
(224 Nhận xét)
6.9
polarjin2017

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 Thêm

€150 EUR trong 3 ngày
(83 Nhận xét)
6.6
MohsanEijaz

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

€250 EUR trong 3 ngày
(83 Nhận xét)
6.2
sloker18

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 Thêm

€200 EUR trong 5 ngày
(78 Nhận xét)
5.7
aubrey03

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 trong 2 ngày
(98 Nhận xét)
5.6
sajidkhan45

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 Thêm

€125 EUR trong 3 ngày
(47 Nhận xét)
5.3
vsprybhanu

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 Thêm

€190 EUR trong 3 ngày
(72 Nhận xét)
5.4
afenache

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 trong 4 ngày
(19 Nhận xét)
5.2
bhupendrayadav

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 Thêm

€148 EUR trong 2 ngày
(22 Nhận xét)
4.3
shahinrahimi

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 Thêm

€100 EUR trong 1 ngày
(20 Nhận xét)
4.0
bluesea1990

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 trong 3 ngày
(2 Nhận xét)
2.5
engelnady

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 Thêm

€90 EUR trong 1 ngày
(1 Nhận xét)
2.3
adampohp79

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 Thêm

€155 EUR trong 3 ngày
(1 Nhận xét)
0.9
Karekin

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 Thêm

€166 EUR trong 3 ngày
(1 Nhận xét)
0.6
€155 EUR trong 3 ngày
(0 Nhận xét)
0.0
anusmita669

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 Thêm

€155 EUR trong 3 ngày
(0 Nhận xét)
0.0
pushv

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 Thêm

€133 EUR trong 4 ngày
(0 Nhận xét)
0.0
€244 EUR trong 2 ngày
(0 Nhận xét)
0.0
rclevenger

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 Thêm

€277 EUR trong 2 ngày
(0 Nhận xét)
0.0