OK continueing my first post, here are my columns of the sheets:Distillery Bottler
(2-3 letter abbreviation)Name or "Vintage"
(date) Cask Type/Specials/etc.
No of Bottles
Date of purchase
(calculated=(TODAY()-"date opened")/365*12)Price paid
(usually £ or €/calculated in £ when bought in DK)Danish Price
(calculated/price paid in DK)Vol
The sheets are: Main, Open, Islay, Islands, Campbeltown, Speyside, Highland, Lowland, Save, Empty, Sold
The main sheet sums up loads of stuff using the SUMIF function, e.g. bottles pr distillery (open and closed). Furthermore bottles pr. region, pr. bottler, etc.
All in all a lot of numbers that I don't really use except the closed/open totals
The total figures of cost are the most scary numbers, so I tend not to look at them much
BTW to keep track of opened ones, they are moved from a region sheet to the "open" sheet and/or the "save" sheet. And when gone they are moved to the "empty" (or "sold" in rare cases). All by just cut & paste.