Find Jobs
Hire Freelancers

VBA Excel automation

$30-250 AUD

Completed
Posted about 5 years ago

$30-250 AUD

Paid on delivery
Please refer to the spreadsheet: I need to look at status, if the status is "Executed" then ignore and go to the next row. It then needs to find the latest date entered for that row, in row 2 this would be 16/11/17, it needs to then put into an array the contract number "2", then comments "Finalising contract" then the date 16/11/17 followed by the latest date header Closed Once they are in an array i need to print them to sheet1 in the workbook for example. See the worksheet for the output required
Project ID: 18994033

About the project

19 proposals
Remote project
Active 5 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
Hello, i've read the description and look at the attached file and i believe i can help you. If you are interested in working with me, please message me so i can ask you few simple follow up questions. Btw i can code this in ~1h and i can start immediately. Thanks, Milan
$35 AUD in 0 day
5.0 (540 reviews)
7.0
7.0
19 freelancers are bidding on average $96 AUD for this job
User Avatar
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$70 AUD in 1 day
4.9 (126 reviews)
7.1
7.1
User Avatar
Hi! I can do this and deliver it tomorrow. I'll do it through VBA But I need an excel file that matches the written example, this one doesn't. Thanks! Felice -------------------------------------
$133 AUD in 2 days
5.0 (27 reviews)
6.7
6.7
User Avatar
Hello. I have good skills in "Excel, Software Architecture, VB.NET, Visual Basic, Visual Basic for Apps". I have checked your project description carefully and i can do it. I 'll do my best till you satisfy if you want me. Contact me please. Thank you. Yang L.
$70 AUD in 0 day
4.8 (116 reviews)
6.1
6.1
User Avatar
Hello there, I am an Excel VBA coder with more than 100+ macros was created. I can do this project for you in 30 mins or less. And I can start right now. I see your attachment I found many ways to complete. Please contact me and I will do it for you. Thanks.
$30 AUD in 0 day
5.0 (152 reviews)
6.0
6.0
User Avatar
Msc computer science. MBA accounts and finance. Mphill in statistics. having seven years of experience in Excel vba and Excel macros. I already done many Excel complex projects like: Excel models designing. Excel dashboards designing. Excel Reporting systems. Excel complex calculators. Cost accounting financial models. sir I can deliver you quality work with guarantee. I already designed these Excel projects. 1. DCF excel financial model. 2. Waterfall Excel model. 3. Pms Excel dashboard. 4. Excel Tracker. 5. Mock up Excel dashboard. 6. Inventory Excel dashboard. 7. Excel Reporting system. 8. Excel lifestyle calculator. I also done many other such projects by using Excel vba, Excel macros and Visual basics.
$250 AUD in 1 day
4.7 (78 reviews)
6.2
6.2
User Avatar
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
$65 AUD in 3 days
5.0 (41 reviews)
5.6
5.6
User Avatar
Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance Thanks
$50 AUD in 0 day
4.9 (40 reviews)
4.6
4.6
User Avatar
Hi Good Day! I've done a lot of job like this one before. I can help you to complete this project in high quality. This is feasible using VBA MAcro. this is the first time I bid for a graphic design here in Freelancer.com but I am knowledgeable of using different graphic/photo editing tool. Please give me a chance to prove to you my skill. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$50 AUD in 2 days
4.9 (36 reviews)
4.5
4.5
User Avatar
I can do the job! looks like a pretty straight forward task. If awarded a do have some questions to clarify (ie dates are not those mentioned and doubts about the contract number to load in an array) I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project, Autocad, pdf, CorelDraw, etc.), web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6. I value and honor customer service so I will be available for help, small adjustments, bug fixes even long after the project has been paid for and closed.
$35 AUD in 2 days
5.0 (20 reviews)
4.2
4.2
User Avatar
Hi, We have gone through your requirements and understood the same. We have been working on excel VBA projects since last 8 years and we would be happy to help you in getting the work done for you. Hoping to get a revert from you. Thank you.
$30 AUD in 3 days
5.0 (1 review)
0.6
0.6
User Avatar
Sounds like it should be a simple project, but I'll want to confirm a couple things about what you want. Should be simple to do though.
$222 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi! I am very interested in your project. I have been using Excel extensively to automate processes at work and to make our workflow easier. I would love to help you out with your project. Thank you for consideration.
$111 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i can do it. i usually do job same as this project. ............................................................ ..........................................................
$155 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Thanks for reading my proposal. I would like to put up a bid for your project. The instructions is in 2 parts. a. Skip records that are "Executed". The macro will read from second line till there is no more entry in the first column. b. Find the latest date. The macro will search from AR backwards (AR, AQ, AP ...). Once it finds a non-empty date, it will extract the date, status and other data and populate the next spreadsheet. I can complete this in one day. Hope to hear from you soon. Tom Goh
$35 AUD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Having good expertise in Excel VBA and good knowledge in programming. Please let me know if I can assist you in this work. Looking forward to work with you. Thanks!!
$140 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I already see your file, it is not too difficult with me, so i can solve it with cheap cost. A short VBA code can solve it. Nice day,
$35 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Developer VBA and C #, Expert in Excel, Word, etc Hello, my name is Ivan. I consider myself a person who can help you in whatever you want and be reliable and do not try to disappoint anyone. I work as a VBA developer in EDAG Mexico. I have worked for public organizations in databases and software maintenance, as well as in VW de México, developing a system based on macros, In my current job, I have worked for Nissan, Audi, Mercedez and VW (again). I have a year and a half of experience and I have acquired important values ​​such as responsibility, honesty and teamwork from those who do not have some independent professional. My specialties are: -VBA for Excel, Word, PowerPoint. -HTML, PHP and JavaScript -C -C # -Web development -Web Scraping
$155 AUD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Lakes Entrance, Australia
5.0
8
Payment method verified
Member since Jul 23, 2012

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.