Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
keeping track of stock moving from one location to another
In this case I don't know where to start.
A shop has 42 different posters, in various quantities, lying flat in a storeroom on level 2. Each day someone rolls some of these posters and puts them in mailing tubes. The rolled posters in the tubes are then taken downstairs to the shop. So that I don't run out of posters I need to keep track of how many are lying flat on level 2, how many I rolled today and how many are on the shop floor. I'm really stuck so any help at all will be most appreciated indeed. Thanks, Tagger. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
keeping track of stock moving from one location to another
Hi Tagger
One simple, yet powerful way to keep track of the inventory is to record all transactions in a simple table. Then you can use a Pivot Table to extract just about any information about your stock. What is upstairs and what is in the shop, what went where and when etc. All it takes is beeing consequent and careful when entering the data. Here is some sample data that you can try in a worksheet with a Pivot Table: Date Article Loc. Items 14-aug Sunflowers L2 40 14-aug Castle L2 53 14-aug Train L2 62 14-aug Cars L2 14 14-aug Trees L2 30 14-aug Cat L2 44 14-aug Dog L2 34 15-aug Castle L2 -4 15-aug Castle Shop 4 15-aug Cat L2 -3 15-aug Cat Shop 3 15-aug Trees L2 -6 15-aug Trees Shop 6 16-aug Castle Shop -2 The first 7 lines are the starting balance. The following 6 lines are transfers from level 2 to the shop. The last line is a sale/shipment. Hope this will give you some ideas. Anders Silvén "DL" skrev i meddelandet ... In this case I don't know where to start. A shop has 42 different posters, in various quantities, lying flat in a storeroom on level 2. Each day someone rolls some of these posters and puts them in mailing tubes. The rolled posters in the tubes are then taken downstairs to the shop. So that I don't run out of posters I need to keep track of how many are lying flat on level 2, how many I rolled today and how many are on the shop floor. I'm really stuck so any help at all will be most appreciated indeed. Thanks, Tagger. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
keeping track of stock moving from one location to another
many thanks for your help. I've never used a pivot table, but I guess now
would be a good time to find out what they are, how they work and why they're useful. I'll give this a try and see what happens. "Anders S" wrote in message ... Hi Tagger One simple, yet powerful way to keep track of the inventory is to record all transactions in a simple table. Then you can use a Pivot Table to extract just about any information about your stock. What is upstairs and what is in the shop, what went where and when etc. All it takes is beeing consequent and careful when entering the data. Here is some sample data that you can try in a worksheet with a Pivot Table: Date Article Loc. Items 14-aug Sunflowers L2 40 14-aug Castle L2 53 14-aug Train L2 62 14-aug Cars L2 14 14-aug Trees L2 30 14-aug Cat L2 44 14-aug Dog L2 34 15-aug Castle L2 -4 15-aug Castle Shop 4 15-aug Cat L2 -3 15-aug Cat Shop 3 15-aug Trees L2 -6 15-aug Trees Shop 6 16-aug Castle Shop -2 The first 7 lines are the starting balance. The following 6 lines are transfers from level 2 to the shop. The last line is a sale/shipment. Hope this will give you some ideas. Anders Silvén "DL" skrev i meddelandet ... In this case I don't know where to start. A shop has 42 different posters, in various quantities, lying flat in a storeroom on level 2. Each day someone rolls some of these posters and puts them in mailing tubes. The rolled posters in the tubes are then taken downstairs to the shop. So that I don't run out of posters I need to keep track of how many are lying flat on level 2, how many I rolled today and how many are on the shop floor. I'm really stuck so any help at all will be most appreciated indeed. Thanks, Tagger. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping Track of - Insurance - Medical | Excel Discussion (Misc queries) | |||
I know Excel can help me with keeping track of due dates | Excel Discussion (Misc queries) | |||
Keeping track of useful macros | Excel Discussion (Misc queries) | |||
TEMPLATE OF FIRST IN FIRST OUT TO TRACK STOCK BUY AND SELL | Excel Discussion (Misc queries) | |||
Help with keeping track of payments | Excel Discussion (Misc queries) |