Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have created a workbook template where I have a 'master' page for an Order
Acknowledgment/Confirmation for a Purchase Order for items that are purchased from one vendor and are waiting to be received. On separate sheets, I have created a similar template to receive the items purchased on multiple Purchase Orders for that one original Purchase Order due to backorders. This is simply for tracking everything on the Original Purchase to insure that all inventory is accounted for without all the confusion and paper trail. What I am wanting to do is have a running total of backordered items for each item ordered on the mater page as new purchase orders for backorderes are entered for that particular Original Purchase Order. If someone could let me know how this is done, I would greatly appreciate it and it would save me a lot of HEADACHE!! I think that I am on the right track and I am close-if all else fails, I could always enter the info manually, but I think that might open the door for more error...I know that it can be done!! Thanks in advance for the answer!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Project Purchase & budget tracking tool | Excel Worksheet Functions | |||
Purchase order... | Excel Worksheet Functions | |||
Purchase order | Excel Discussion (Misc queries) | |||
purchase order counter in excel purchase order template | Excel Worksheet Functions | |||
I want a purchase order that includes page number (if to be order. | New Users to Excel |