Find Jobs
Hire Freelancers

VBA/Macros Project

$750-1500 USD

Completed
Posted over 3 years ago

$750-1500 USD

Paid on delivery
Need to be able to send emails to individuals daily based on cell value. Need to be able to then parse the required data sent in the return email back into the excel cell. Working to avoid too much copying and pasting and automating this process. At the end of each day the excel sheet needs to save into a separate table and be cleared back to zero. We are trying to better forecast daily revenues and how much money we need to transfer into our main account. We need to automatically message our agencies each day at the same time, have them respond and the data populate into excel. I know how to send emails from excel but don't know how to code to parse data and to clear the excel sheet each day.
Project ID: 27931821

About the project

24 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
* MsEXCEL expert with strong email integration experience. American English is my only language. USMC veteran. At your earliest convenience, please attach any data/email/report/workbook sample(s) you may have to this private chat message thread so we may better analyze and discuss your requirement. Many thanks in advance! Greetings from Easton PA, USA.. {smile} Highly experienced (25+ years) MsACCESS/MsEXCEL/SQL/VBA/VB.Net Business Information, Programming, and Database EXPERT with GURU / MENTOR level technical credentials at [login to view URL] and www.vbcity.com. Excellent Automation, USER FRIENDLY Application Development, Application Maintenance, Debugging and Troubleshooting skills. Excellent Data Analytics, Data Extraction, Data Integration, Data Manipulation, Data Mapping, and Data Presentation skills. Strong Accounting, Business Math+Statistics, Bills-of-Material, Finance, Inventory, Job/Project/Standard Costing, Manufacturing, Order/Quotation Processing, Payroll+Time, Project Management, Sales+Marketing, Scheduling, and US Tax application knowledge. MBA. BS Accounting. Marketing minor. Graduated 'Summa Cum Laude' (with the very highest of honors). USMC Combat Veteran. American Citizen. Well-written and well-spoken American English is my first and only language. Confidentiality and satisfaction guaranteed. Cheers. Respectfully, Bill.
$989 USD in 7 days
5.0 (59 reviews)
6.5
6.5
24 freelancers are bidding on average $966 USD for this job
User Avatar
Hi, Greetings! ✅checked your project details: VBA/Macros Project ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$900 USD in 7 days
4.9 (439 reviews)
8.3
8.3
User Avatar
Dear Employer, I understand you need to automate following: - Auto email data to people. - Auto extract data from mails to Excel file. - Auto dump data from excel file in main folder and clear the excel file. Kindly share some more details. I am an expert and will do a professional job for you. Kindly check my previous reviews once!! Thanks, Ashish
$750 USD in 3 days
5.0 (245 reviews)
8.1
8.1
User Avatar
Hello, If you have Outlook installed on your system and you use it on your current handle, then we could utilize it and write the VBA code for doing the parsing and managing the Excel worksheet in background process. So, on every certain time-range the VBA code will process the excel based on input file you pre-determined, send the email over Outlook, download the message, check if the sender is valid for further process, parse the body, and update your server. That's the flow and all done using VBA code. Let me know if this flow is OK for you or you need to add/modify it Best Regards, Khamid
$1,000 USD in 3 days
4.5 (35 reviews)
8.0
8.0
User Avatar
Hello,I have read the job description and I am interested in this job. I have 8 years experience in developing products using Data Processing, Visual Basic, Visual Basic for Apps, Excel and VB.NET. I have read your requirements and am ready to start working for you. • Attractive and unique front end •Functional backend with quick response time •Customer support even after developing a product is awaiting your response. My Portfolio: https://www.freelancer.com/u/AwaisChaudhry?w=f Regards,
$1,500 USD in 26 days
5.0 (4 reviews)
6.0
6.0
User Avatar
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
$750 USD in 1 day
4.9 (35 reviews)
5.3
5.3
User Avatar
Hi! Im an Excel VBA and Google Sheets SCRIPTS expert. To achive this a recomend Google Suite plataform. To retrive send share and process, its working fine. Im glad to show you a pre-project to evaluate functionalities. Important, i think can be done a little cheaper than this! Regards Juan
$750 USD in 10 days
5.0 (17 reviews)
4.7
4.7
User Avatar
Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. i can handle your VBA /Macros project perfectly well, i can develop a macro that can able to send emails to individuals daily based on cell value,parse the required data sent in the return email back into the excel cell. I am a graduate of computer science. Also, I have several good records in this field as I have been working in this field for about 6+ long years. I have Great experience in Data visualizations, building dashboards using Excel, i am proficient in VBA, Gscript e.t.c I have great expertise on Data entry and excel and Analysis. also have proficiency in MS office, Google analytics and QuickBooks and 10-Key KPH typing speed with zero errors. Working with me will surely bring you many good as I am very creative and persuasive in nature. Also, I can handle things diplomatically with full professionalism. With full guarantee, I can assure you the deliverables you have asked for in the job description. Regards Atemenu .D
$750 USD in 2 days
4.9 (13 reviews)
4.3
4.3
User Avatar
HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects similar to your requirement using VBA,RPA,excel power queries and other Technologies. I can give my full effort to deliver the project in on time with 100% quality and accuracy...I'm waiting for your kind response.
$750 USD in 3 days
5.0 (5 reviews)
2.4
2.4
User Avatar
Hello, I’d really like to work with you on this one if possible! I’m Usman . I have lots of experience in data typing, data entry, web research, database administration, ad posting, data research, data mining, data extracting, data scraping, virtual assistant & Excel. I think my skills and experience will help you and your farm. However, If you take a look at my work and feel that I could help you. I am working on another popular online marketplace with 3 years of a permanent position with a real estate agency. You’ll get all the expected stuff like a great professional service and a fast turn around, at a bit less, and I get a bit more exposure. If the above offer sounds like something you would be interested in, I’d love to hear from you. Regards, Muhammad Usman
$1,125 USD in 7 days
5.0 (2 reviews)
0.2
0.2
User Avatar
Hi, sir. Thank you for sharing your project VBA/Macros Project, and I would be very happy to help you with your business. Let me share you with my expertise in Visual Basic, Visual Basic for Apps, VB.NET, Excel, Data Processing and relevant technologies. I have been doing a lot of work for this type of job. More detail you may be interested in will be provided over chat. You may also check my profile summary and portfolio items. As per your requirement, I can give you perfect answers as well. Your project immediately can be started and is looking forward to my participation. Best,
$1,250 USD in 13 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Pierre, United States
5.0
1
Payment method verified
Member since Oct 27, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.