Automating my reporting needs

€30-250 EUR

Fullført

Lagt ut

nesten 5 år siden

€30-250 EUR

Betalt ved levering

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.

Prosjekt-ID: 19340490

Om prosjektet

24 forslag

Eksternt prosjekt

Aktiv 5 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@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 same (updated) files every time they are run, as well as scripts which grab data from all files in a folder, or allow the user to choose the file from a prompt, so however you want this implemented it will run smoothly I've deliberately bid fairly low as I don't have a lot of reviews at the moment, the bid price I've entered is fine and will not be negotiated provided the project is as described

€70 EUR om 5 dager

5,0

(4 omtaler)

3,2

24 frilansere byr i gjennomsnitt €158 EUR for denne jobben

@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. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

€220 EUR om 3 dager

4,9

(337 omtaler)

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 the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards

€200 EUR om 7 dager

4,9

(229 omtaler)

6,9

@MohsanEijaz

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

€250 EUR om 3 dager

5,0

(88 omtaler)

6,3

@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 the attached workbook as well… I can write the macro as requested. Kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.

€200 EUR om 5 dager

5,0

(91 omtaler)

6,0

@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 can check on my profile. So executing this project should not be a problem for me. Hope to chat with you soon mate! Thanks Sajid Khan

€125 EUR om 3 dager

4,9

(56 omtaler)

5,5

@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 om 4 dager

5,0

(20 omtaler)

5,2

@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 Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra

€190 EUR om 3 dager

4,8

(79 omtaler)

5,5

@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 have developed couple of automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you

€148 EUR om 2 dager

4,8

(29 omtaler)

4,8

@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 om 3 dager

5,0

(13 omtaler)

4,4

@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 have quick chat on this. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} • Translating ...........................................{English, Turkish, Farsi} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks, Shahin

€100 EUR om 1 dag

5,0

(30 omtaler)

4,4

@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 developer with over 10 years, so that I can bring your idea to live and you can reach the goal absolutely with me. I am confident that you will be completely satisfied with the quality, timeliness, and professionalism of my work. I would like to share my valuable experience with you, also hope long term relationship with you. Looking forward to work for you Thanks

€155 EUR om 3 dager

5,0

(2 omtaler)

3,0

@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 Excel, VBA and Data processing as I've been developing many projects for 15+ years. I'm just new to freelancing. It's my pleasure to get your choice and to work with you. I'm sure you will be fully satisfied. Waiting for your appreciated reply. Thank you Regards Mohammed

€90 EUR om 1 dag

5,0

(6 omtaler)

3,1

@mscosmo

I am an information technology student with Advance PC skills I go extra mile to get the job done I promise you will not be disappointed with my work

€66 EUR om 2 dager

0,0

(0 omtaler)

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 requiring automation.

€133 EUR om 4 dager

0,0

(0 omtaler)

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 Accuracy. I look forward to hearing from you Thank You.

€155 EUR om 3 dager

0,0

(0 omtaler)

0,0

@NoSonforhim

I have 20 years in Database Developing, Programming, Training, and Accounting Solutions / Finance with Computer

€133 EUR om 3 dager

5,0

(1 omtale)

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 finance for 15 years and have done and seen it all. I’m new to freelancer so I’m trying to get some rankings. Free for call, email, webex to discuss.

€277 EUR om 2 dager

0,0

(0 omtaler)

0,0

@Leonard193

i am interested in this project, i have developed several similar project, please let me know if you need any help on this. i need to know more particular details so that can developed a sustaining and useful excel macro.

€133 EUR om 2 dager

0,0

(0 omtaler)

0,0

@satishchowdaryd9

I have total 3.7 years of experience in VBA Automation and have professional experience with MNC's. I seen entire your project and excited to work in this project.

€155 EUR om 3 dager