I have a spread sheet which I keep a record of all my sowing (plants)
I want to keep an automatic seed stock count by varity how can I do this.
On my sheet i have
Batch No, Varity, Qty, Customer, Date Sown, Delivery Date,
12345 Bastile 100, van Dyke 12/12 25/02/06

What I want to do is every time I sow Bastile it automaticly takes the
amount off my stock on another sheet .We sow 25 varitys a day so can not
use cell No's must use names but how does excel do this as each name will not
apper in a set cel.
Help please thank you