Need a Purchase Ordering System in Excel as a Workbook -
- or -
Post a project like this2358
$$$
- Posted:
- Proposals: 16
- Remote
- #1762060
- Awarded
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
1873562188945418934301909410
Description
Experience Level: Expert
Estimated project duration: less than 1 week
General information for the business: We are an electrical contractor
Description of excel work: We need a complete excel workbook developed for our purchase ordering system. We currently use Excel and I will provide a sample sheet of what we have been using. We use a new workbook per each project we do. My goal is to create something with all the current information but to also be able to add either a code line item or something like that where I can basically go back through the entire workbook and request how much of any one material item we have purchased. For example if you open the workbook I have attached as an example and see PO 001 tab (at bottom) and you see we ordered 12,000 feet of 14/2wg (which is wire) - I would like to be able to go back after we use many tabs (or PO sheets) and be able to get a total of 14/2wg wire or any other line items we order.
Extra notes: I have included a used PO Book from an old job as an example - Note the tabs went to 100 pages but I deleted the rest for example purposes. I have also attached here a complete blank PO Book to show what exactly we start with.
Description of excel work: We need a complete excel workbook developed for our purchase ordering system. We currently use Excel and I will provide a sample sheet of what we have been using. We use a new workbook per each project we do. My goal is to create something with all the current information but to also be able to add either a code line item or something like that where I can basically go back through the entire workbook and request how much of any one material item we have purchased. For example if you open the workbook I have attached as an example and see PO 001 tab (at bottom) and you see we ordered 12,000 feet of 14/2wg (which is wire) - I would like to be able to go back after we use many tabs (or PO sheets) and be able to get a total of 14/2wg wire or any other line items we order.
Extra notes: I have included a used PO Book from an old job as an example - Note the tabs went to 100 pages but I deleted the rest for example purposes. I have also attached here a complete blank PO Book to show what exactly we start with.
Dennis C.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
26 Dec 2017
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Dennis,
Why workbook - I think it will be better if you get yourself a web based stystem deployed on cloud, which will allow you to work over phone and other devices, Plus allows you to send estimate online through system.
I have done a similar thing for electrical contractor in Australia and It seems yourrequirements are same
Let me know your thoughts
Thanks
Chetan
527186
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies