I am trying to create a spreadsheet to keep tabs of all our printer cartridges at work and have succeeded in using vlookups to show the data I want on the order form. The problem I have is when I want to order some more cartridges. Is there a macro I can write or a formula I can use that will keep a running total for me.
I have the two worksheets (itinerary and order) and when the order is made I want it to add the quantity ordered to the current stock levels on the itinerary sheet.
From that I’m sure I will be able to work out when users take the cartridges from the stock.
[/url]
I have the two worksheets (itinerary and order) and when the order is made I want it to add the quantity ordered to the current stock levels on the itinerary sheet.
From that I’m sure I will be able to work out when users take the cartridges from the stock.
Printer Stocktest.xls | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | PoductCode | Description | Man.Code | Amount | TypeOfUnit | UnitofMeasure | BestPrice | SupplierCode | Supplier | CurentStock | lastorder | NewStock | ||
2 | B001 | BrotherFax-8250pDrum | DR-200 | 1 | Fax | each | 78.50 | 1003 | IanSmiths | 1 | 1 | 2 | ||
3 | B002 | BrotherFax-8250pToner | TN-200 | 1 | Fax | each | 17.00 | 1001 | Danwood | 2 | 2 | 4 | ||
4 | C001 | CanonBJC-1000 | BC-05 | 1 | Printer | each | 25.87 | 1001 | Danwood | 3 | 8 | 11 | ||
5 | C002 | CanonBJC-250 | BC-05 | 1 | Printer | each | 25.87 | 1001 | Danwood | 4 | 8 | 12 | ||
6 | H001 | DeskJet3820Black | C6615D | 2 | Printer | each | 15.00 | 1003 | IanSmiths | 4 | 12 | 16 | ||
7 | H002 | DeskJet3820Colour | C6578A | 2 | Printer | each | 33.80 | 1003 | IanSmiths | 4 | 4 | 8 | ||
8 | H003 | DeskJet3822Black | C6615D | 4 | Printer | each | 15.00 | 1003 | IanSmiths | 4 | 4 | 8 | ||
9 | H004 | DeskJet3822Colour | C6578A | 4 | Printer | each | 33.80 | 1003 | IanSmiths | 4 | 4 | 8 | ||
10 | H005 | DeskJet5650Black | C6656A | 1 | Printer | each | 12.40 | 1003 | IanSmiths | 4 | 4 | 8 | ||
11 | H006 | DeskJet5650Colour | C6657A | 1 | Printer | each | 18.53 | 1003 | IanSmiths | 4 | 4 | 8 | ||
Itinerary |
[/url]