LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Running totals on Purchase Order tracking

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Project Purchase & budget tracking tool Chuck[_3_] Excel Worksheet Functions 0 November 1st 07 10:14 PM
Purchase order... Bossgobbler Excel Worksheet Functions 3 May 19th 06 10:02 PM
Purchase order dee Excel Discussion (Misc queries) 2 October 25th 05 01:39 AM
purchase order counter in excel purchase order template Brandy@baoco Excel Worksheet Functions 0 February 23rd 05 06:17 PM
I want a purchase order that includes page number (if to be order. Angela New Users to Excel 1 December 3rd 04 04:39 PM


All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"