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)
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
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