Find Jobs
Hire Freelancers

Using VBA to minimize admin work and improve process efficiency.

$30-250 SGD

Ολοκληρώθηκε
Αναρτήθηκε πάνω από 5 χρόνια πριν

$30-250 SGD

Πληρωμή κατά την παράδοση
We are a landlord looking to automate and improve our administrative process of notifying tenants who do not pay their rent. Currently, our account department's system will produces an excel sheet called the statement of accounts (screenshot attached). It is then printed out and handed to an employee in the legal department which has to manually key in the details from the statement of accounts to create the letter of demand which is sent to tenants. This process is time consuming and can be automated through VBA. Unfortunately, a simple mail merge will not work as the system generates new excel sheets for each tenant Essentially, we need to create a mail merge, but with dynamically adjusting fields within the excel sheet, as different tenants owe various amounts. Screenshots of both the Letter of Demand (highlighted fields indicate which need to be manually updated) and Statement of accounts have been included.
Ταυτότητα εργασίας: 17765487

Σχετικά με την εργασία

33 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$150 SGD σε 2 ημέρες
4,9 (89 αξιολογήσεις)
6,0
6,0
33 freelancers are bidding on average $161 SGD for this job
Avatar Χρήστη
Hello! This is vibrant webtech and I was glad to see that you're looking for help for project Using VBA to minimize admin work and improve process efficiency.. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.
$250 SGD σε 4 ημέρες
4,9 (332 αξιολογήσεις)
7,9
7,9
Avatar Χρήστη
Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to automate the process of creating the Letter of Demand based on data entered in your Excel spreadsheet. this can be done through VBA code with which I'm very comfortable. The final application will be an Excel file containing code that will run on desktop PCs. I've delivered more than 240 projects in the last 5 years and this makes me very confident with your task. I can deliver the project within 2-3 days including all required revisions for $160. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon. Sincerely, Paris Pallas
$160 SGD σε 3 ημέρες
4,9 (239 αξιολογήσεις)
7,5
7,5
Avatar Χρήστη
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure. Have worked in similar projects. Willing to take up your project. Thank you, Regards.
$155 SGD σε 3 ημέρες
5,0 (111 αξιολογήσεις)
6,3
6,3
Avatar Χρήστη
PhD in computer science having seven years of experience in Excel development and visual basics.
$250 SGD σε 1 ημέρα
4,7 (73 αξιολογήσεις)
6,2
6,2
Avatar Χρήστη
Hello, I am ready to discuss project with you. Being experienced in working on excel/vba/macro tasks of various complexities, I can help you in getting your task done quickly and efficiently. I will help you out with form in excel which you can use to generate letter of demand for different tenants with respective figures as you want. Looking forward to have further project discussion on chat. Thanks. Vimal Arora
$172 SGD σε 3 ημέρες
4,8 (101 αξιολογήσεις)
5,8
5,8
Avatar Χρήστη
Hello thee, as an expert in excel and VBA, i can help you to develop a script that will get the required data and auto-populate your sheet and word document. Please contact me and let us talk more about your project. Thanks
$111 SGD σε 3 ημέρες
5,0 (83 αξιολογήσεις)
5,8
5,8
Avatar Χρήστη
am not a random bidder.. Please ping me if you ar einterested with my proposal and share more detail.. thank you..
$250 SGD σε 3 ημέρες
4,9 (28 αξιολογήσεις)
5,0
5,0
Avatar Χρήστη
Hello. I'm interested in your project as very well. I'm excel developer and can work as full time. And I have good experience in vba develop. I am mastering in vba and excel. I can show you my work if you want. I think you will allow me with your project. If you give me opportunity , then I will do best for you. I’m looking forward to your reply and want to work with you. Thanks.
$150 SGD σε 3 ημέρες
5,0 (9 αξιολογήσεις)
5,1
5,1
Avatar Χρήστη
Hi Good Day! May I know if you are using Office outlook? I can do that using Excel and outlook integration. I am a PMO Analyst and my primary task is generating a Financial reports. I am exposed on different Excel Formulas and functions. I am also a VBA Macro developer which I think a big factor to complete this task. Feel free to message me anytime to discuss  this project. Thank you!
$50 SGD σε 2 ημέρες
4,9 (36 αξιολογήσεις)
4,5
4,5
Avatar Χρήστη
Hello friend, I was analyzing your problem and I know how to help you. With a vba form it is possible to do what you need. I await your confirmation to start. Greetings.
$211 SGD σε 4 ημέρες
5,0 (10 αξιολογήσεις)
3,8
3,8
Avatar Χρήστη
Hi I read your description and saw your attachment. I have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development. I am sure i can handle your request
$90 SGD σε 3 ημέρες
5,0 (10 αξιολογήσεις)
4,0
4,0
Avatar Χρήστη
Hi,I have read your requirements of Using VBA to minimize admin work and improve process efficiency. and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss further. You can reach me at any time on online . I have also a few clarifying questions on the project.I’m an Expert, Honest, Sincere, Quick learner and Responsible worker as I’m taking my work like my Responsibility. kind regards.
$150 SGD σε 4 ημέρες
5,0 (3 αξιολογήσεις)
2,9
2,9
Avatar Χρήστη
Hello there, how are you today? I read your project description and I understand that you need a vba expert to automate the process of statement and letter of demand generation. I can provide you with exactly what you require. send me a message so we can discuss additional details.
$250 SGD σε 7 ημέρες
4,0 (4 αξιολογήσεις)
2,9
2,9
Avatar Χρήστη
This is a very simple VBA. You have an excel statement and based on it you need to create a letter(print). Please provide the the letter in WORD and statement in Excel. ------------------------------------------- I am a lazy person so I started automating my work and became an expert in it. I have handled huge data and processed them with my automation skills. I have 9 years of experience in the Excel sheets and macro. Handled huge data in office. Completed many automation projects.
$36 SGD σε 1 ημέρα
5,0 (3 αξιολογήσεις)
1,5
1,5
Avatar Χρήστη
hi.i would be happy to develope the same system using ms access,wich is also part of ms office. ms access is a more realistic database management infrastructure. please contact me for further assistance kind regards enrico
$250 SGD σε 10 ημέρες
5,0 (2 αξιολογήσεις)
1,2
1,2
Avatar Χρήστη
Hi, I'm a former subject matter expert/team lead in a call center. During that career i have manage to gain knowledge and experience in coding Excel Macro. If you want i can send you some of my work for your reference. Thanks, Gerald
$166 SGD σε 10 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I know how to do this mail merge using VBA in Visual Studio. I am with the understanding that I need to read this excel sheet which has dynamically adjusting fields (variation) and perform a mail merge to generate the Letter of Demand. Do you want a Windows Form user interface?
$94 SGD σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
In order to do this with the least amount of back and forth testing, it would be helpful to see as many examples of the tenant spreadsheets as possible. Afterwards, we can test the results by comparing them to past letters you have produced. Also, it would be helpful to know what kind of variations are to be expected in the spreadsheet. For example, will certain values always be in the same cell.
$166 SGD σε 2 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I am a professional programmer, have more than 8 years' experience, I am very proficient with VB, have done lots of programs using VB in Excel, so I am proper for your requirement, hope to talk about the details.
$150 SGD σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
i have already created such macro for my company's client, i just need to do some edits.
$51 SGD σε 2 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της SINGAPORE
Singapore, Singapore
5,0
3
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Σεπ 14, 2018

Επαλήθευση Πελάτη

Άλλες δουλειές από αυτόν τον πελάτη

Compare two excel sheets
$30-250 SGD
Simple VBA formatting Macro
$12-30 SGD
Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.