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.