Find Jobs
Hire Freelancers

Excel Macro/Google App script - Purchase Order Generator

$30-250 USD

Completed
Posted about 3 years ago

$30-250 USD

Paid on delivery
Looking to create an excel macro/google apps script (for google sheet) - that will generate a PDF/Excel/Gsheet Purchase Order. The intent is as follows: 1) There is a spreadsheet with multiple worksheets. a) Worksheet Products Master - Lists all the products b) Worksheet Suppliers - Lists all the supplier name and other info There will be an input page - where a person will go and put in the SKU name and put in the quantity and the script will populate the information from the sheets listed in step a and b and then provide a button to generate a Purchase Order document as a Gsheet/Excel/PDF file The sheet will be pulling text and images such as product image and upc from links listed in the worksheets (a and b) as part of generating the purchase order
Project ID: 29403672

About the project

8 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
Hello there, I read the brief. I got what you want. Let's discuss more detail in PM. Thank you//Fanzy
$30 USD in 1 day
4.9 (13 reviews)
3.0
3.0
8 freelancers are bidding on average $160 USD for this job
User Avatar
Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project. Also, I can send some of my VBA apps. I can complete your job successfully in your mind. Wishing for your response. Let me try at your job. Thanks
$140 USD in 1 day
4.9 (99 reviews)
6.1
6.1
User Avatar
Hi. I have written many automation Excel VBA macros also Google scripts. Ready to write your project. Will complete within 3 days
$600 USD in 3 days
4.9 (110 reviews)
6.0
6.0
User Avatar
Greetings Thanks for checking my proposal. I have understood your project and can start your project immediately. i have vast experience as Manager Accounts and Advance Excel so I would complete your template For Purchase Order Accordingly. I am now full- time freelancer after job experience of more than two decades. It included more than decade as Manager in Public Listed Companies. Having In depth knowledge of Excel for data analysis, Pivot Table and charts, Dashboard, Power query, Macros, User Forms, Advance filters, VBA, Financial reporting by using complex Functions. I have also developed many softwares in MS Access. It is my practice to do one project at a time therefore I would assist you full time according to your available time. You can check my scores and reviews Hoping for the positive reply from your side for a long-lasting working relationship. Regards
$50 USD in 2 days
5.0 (29 reviews)
4.5
4.5
User Avatar
Hi there, Thanks for posting a job on freelancer and for it being so detailed. I understand that you need a PO generation macro with the SKU details being pulled from the Product specifications and suppliers sheets. We should be able to get it done in a day or two. We are a team of trained professionals with years of experience in Ms Excel and VBA. Hit us up and we can talk in detail. Regards, Nikita And her team at Affiliazion
$89 USD in 2 days
5.0 (7 reviews)
3.3
3.3
User Avatar
Hello, I can assist you to develop Excel Macro to generate PO with minimum manual efforts. I have strong VBA & Excel sheet skills to automatize routine Excel tasks. I have 15+ years solid corporate experience in designing Excel templates for reporting and data processing. I have been working with excel as an accountant and have explored excel formulas deeply to cater for the different financial/admin reports. I strive for automatize Excel sheets to the maximum possible extent to minimize manual input and reduce labor and human errors. I can develop custom functions/formulas using VBA to automate routine tasks. I can start immediately and fulfill the task in the shortest possible time.
$140 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Ashburn, United States
4.9
105
Payment method verified
Member since Sep 11, 2014

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.