jspeer
04-04-2008, 01:25 PM
Hi all,at work we currently have a purchase order system where we write everything out on paper. Whenever someone asks we will type one out on a customized excel 2003 file, print it out and fax it to them or e-mail it to them.
Recently I have been asked to see if we can computerize this data so that we will be able to more easily figure out information from the purchase order such as how many items were ordered, etc.
What I have so far is our excel Purchase order file. Inside this file I have a second worksheet that pulls the information from the first page and puts it in the right format. Each line item from a purchase order is contained in a row. Every purchase order can contain between 1 and 20 items.
What I would like to do is have a button on the purchase order called update master list that they can click when the purchase order is complete. When the user clicks this button I want excel to open a "master list" and append each item from the purchase order and then save itself and close.
From there whenever we want to look up a purchase order we can open that master list and filter by item, PO#, date, etc.
I know we can do this easier within an Access database however I know we can also do this within Excel with code or a macro and I'm at the point where it's bugging me that I can't find information on how to do this easily.
Anyone have any ideas on how to start with this proejct?
Recently I have been asked to see if we can computerize this data so that we will be able to more easily figure out information from the purchase order such as how many items were ordered, etc.
What I have so far is our excel Purchase order file. Inside this file I have a second worksheet that pulls the information from the first page and puts it in the right format. Each line item from a purchase order is contained in a row. Every purchase order can contain between 1 and 20 items.
What I would like to do is have a button on the purchase order called update master list that they can click when the purchase order is complete. When the user clicks this button I want excel to open a "master list" and append each item from the purchase order and then save itself and close.
From there whenever we want to look up a purchase order we can open that master list and filter by item, PO#, date, etc.
I know we can do this easier within an Access database however I know we can also do this within Excel with code or a macro and I'm at the point where it's bugging me that I can't find information on how to do this easily.
Anyone have any ideas on how to start with this proejct?