create excel macro for a purchase order

Completed Posted 7 years ago Paid on delivery
Completed 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

Excel Visual Basic

Project ID: #12286171

About the project

22 proposals Remote project Active 7 years ago

Awarded to:

MimiFL

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 mess More

$55 AUD in 1 day
(396 Reviews)
6.7

22 freelancers are bidding on average $130 for this job

P0L

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
(263 Reviews)
7.0
ksriniravi

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 Reporti More

$50 AUD in 3 days
(149 Reviews)
6.6
zebracaro

i can do it for you quickly and exactly

$150 AUD in 3 days
(103 Reviews)
6.4
asin1987

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 More

$155 AUD in 3 days
(57 Reviews)
6.3
vlayausa

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
(128 Reviews)
5.8
macroPOL

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 feedbac More

$111 AUD in 3 days
(64 Reviews)
5.7
KavTan

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 lin More

$250 AUD in 7 days
(37 Reviews)
5.4
JITINGOYAL1992

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 n More

$111 AUD in 2 days
(24 Reviews)
4.6
telfordm

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 simil More

$60 AUD in 3 days
(12 Reviews)
4.3
CanadianQuality

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 More

$222 AUD in 3 days
(3 Reviews)
3.1
miltoncalebm

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 a More

$155 AUD in 4 days
(3 Reviews)
1.6
bosaonline

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
(1 Review)
1.4
rubypaghunasan85

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 More

$111 AUD in 3 days
(3 Reviews)
0.8
sowmyabhat16

A proposal has not yet been provided

$155 AUD in 5 days
(0 Reviews)
0.0
Towfeq

A proposal has not yet been provided

$88 AUD in 3 days
(0 Reviews)
0.0
mascotsoft4

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 befor More

$194 AUD in 6 days
(0 Reviews)
0.0
don252

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' More

$30 AUD in 1 day
(0 Reviews)
0.0
handresc1127

A proposal has not yet been provided

$90 AUD in 3 days
(0 Reviews)
0.0
manas009in

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). *C More

$155 AUD in 5 days
(0 Reviews)
0.0