Find Jobs
Hire Freelancers

create excel macro for a purchase order

$30-250 AUD

Completed
Posted over 7 years ago

$30-250 AUD

Paid on delivery
We have a stock level listing for different suppliers, up to 100 line items for each supplier in various excel worksheets. We order items to replenish stock levels back to a minimum stock level. I would like to be able to enter the required amount of each item and to then have this transfer to a purchase order template. I only want the PO to include those lines that we have an order quantity for. (not the full 83 lines). I have attached the sheet we use for one of our suppliers. the others are all largely the same. I'm happy to take other suggestions on how best to do this. cheers Clint
Project ID: 12286171

About the project

22 proposals
Remote project
Active 7 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
Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel jobs (both with formulas and macros) and i've never had a single problem. If you are interested please message me so i can ask you couple of questions. Basically i m interested how many different worksheets you have and how much they differ from one another. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Thanks, Milan
$55 AUD in 1 day
5.0 (396 reviews)
6.7
6.7
22 freelancers are bidding on average $130 AUD for this job
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 AUD in 3 days
4.9 (263 reviews)
7.0
7.0
User Avatar
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. . I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$50 AUD in 3 days
5.0 (149 reviews)
6.6
6.6
User Avatar
i can do it for you quickly and exactly
$150 AUD in 3 days
4.9 (103 reviews)
6.4
6.4
User Avatar
Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on skype as well to discuss more: ashish260287 Thanks and Regards, Ashish Singhal PLEASE CHANGE THE ATTACHED FILE'S FORMAT TO XLSM BEFORE USING.
$155 AUD in 3 days
5.0 (57 reviews)
6.3
6.3
User Avatar
Hello, I am proficient with Excel and VBA and I would love to help you with this project. Please contact me for more information.
$111 AUD in 3 days
4.9 (128 reviews)
5.8
5.8
User Avatar
Hello, I am Excel and VBA expert. I can write macro. All completely automatic. Sheet "PO" will be automatically filled in when you select it. Please note that I have 100% completion rate and 5-star feedback on 50 projects.
$111 AUD in 3 days
5.0 (64 reviews)
5.7
5.7
User Avatar
I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction. I have created Dashboards and Other Excel software for my clients. Please visit my link to know more: https://www.freelancer.in/u/KavTan.html
$250 AUD in 7 days
4.8 (37 reviews)
5.4
5.4
User Avatar
Greetings I am a Chartered Accountancy student and I provide a range of services majorly focusing on excel, data entry, word, accountancy and other allied services. I have been working on this platform for two years now and have got good reviews for my work. Looking at the project description I can assure you that I can execute this efficiently and can start working immediately. I am extremely flexible with time and can dedicate more than 12 hours a day on this project. I believe in making long term relationship and client satisfaction is my top priority. Looking forward to hear from you and discus in details. Regards Jitin Goyal
$111 AUD in 2 days
4.8 (24 reviews)
4.6
4.6
User Avatar
Hi Clint, I am a native Australian Finance professional (Melbourne based) with over 15 years experience using Excel. I can help you with this project in a timely and efficient way. I have recently completed a similar project in Airtasker. I would recommend using a pivot table to summarize the information in the PO for you. I could set it up so that the PO would look very similar to how the current PO appears. I would welcome the opportunity to discuss your project further and to work with you. Regards Melanie
$60 AUD in 3 days
5.0 (12 reviews)
4.3
4.3
User Avatar
Native English speaker. Excel/VBA expert. I've looked at your file and I can definitely do this for you. I bid high because the work I provide is of high quality. Would love to work with you on this. Feel free to PM me if you'd like to chat! Best, Jay
$222 AUD in 3 days
5.0 (3 reviews)
3.1
3.1
User Avatar
Hello, Your project to make Purchase Orders is very interesting and I would love to help you with it. If you have all your POs or inventory in a single Excel workbook I can adjust the workbook to generate the POs as needed. If you manage separate Excel workbooks for each POs I can make an Excel Add-In that will generate the POs for each file. If you manage separate files and want to have them all in one, we can talk it over and I can show you the advantages. I have experience making this type of excel databases. I have worked developing and maintaining Excel databases with more than 1,000,000 cells of information and making Access databases for a large multinational organization. I also have experience writing VBA code for Office products. I recently finished a project that calculated the distance between more than 10,000 GPS coordinates and sends an email automatically with an attached mail merge and made corporate dashboards along with data import/export macros. I am Canadian so I am a fluent English speaker. I also speak fluent and native Spanish speaker since I have lived most of my life in Mexico and Guatemala. I am currently doing volunteer work in Mexico. Thank you for considering my offer. Greetings, Milton Mykiwka
$155 AUD in 4 days
5.0 (3 reviews)
1.6
1.6
User Avatar
I can develop your Purchase Order form handler program. Please let's chat to get started. I have some ideas. Thank you.
$100 AUD in 3 days
5.0 (1 review)
1.4
1.4
User Avatar
have a nice day sir/ma'am, I'm so willing to do the project you have posted, I hope you will give me a chance to do the job. I'm a hardworking person and can do the task efficiently and accurately and I am also a fast learner, I can get instruction easily. I hope you will award this project to me. Thank you..!!!
$111 AUD in 3 days
5.0 (3 reviews)
0.8
0.8
User Avatar
A proposal has not yet been provided
$155 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$88 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Client, Greeting of the day ahead !!! Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned .I have checked your requirements.i have right skills to work on this assignmentWe find our expertise, skills and capabilities are perfectly blends with your project requirements because we have already worked on many projects. You'll love the whole layout, interface design , cross-browser compatibility and mobile-device-friendly interfaces that we design Our team has created over dozen of windows, and web based appliations iPhone/iPad games and apps, and over 10 Windows and Linux server APIs and security tools Don't waste any more time in your development We take care of all these things for you . Advanced custom coding for our clients. Anytime. [Removed for encouraging offsite communication which is against our Terms and Conditions.]. plz add me to discus I am ready to discuss with you Looking forward to hear from you. with best Regards
$194 AUD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there. I assume that you will keep this way or system of placing orders and that you only require a simple macro. If so, I could give you that within 24hours. That macro will be installed as an Excel Add-in. I'll teach you how to add that macro in Excel's custom ribbon so that that macro can be called from other workbooks. I have initial assumptions: 1. Details' line in "PO" sheet always starts at row 20. 2. Detail lines on other excel files are also 18 lines. Kindly clarify if otherwise so I could have a better understanding of your requirement. Regards, Don P.S. I'm a new freelancer in this site, but I have years of experience doing this kind of job and other admin. work.
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$90 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have done lot of projects on Excel and VBA, including: *Desktop Automation for an IT company *Designing itinerary (from raw data) of guests visiting in a hotel (about 15,000 guests visiting in 5 days period). *Created a meeting tracker macro for an individual person. *Lot of projects on formatting and reformatting of raw data. Regards, Maanas
$155 AUD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Osborne Park, Australia
5.0
4
Payment method verified
Member since Dec 6, 2016

Client Verification

Other jobs from this client

I would like a logo designed.
$40 AUD
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.