Excel to track inventory?



I'm currently using MS Excel (2002) to keep track of inventory and sales in
a VERY small home-based business. Would it be possible to set up something
in Excel so that when I entered a sale on one work*** it would
automatically be subtracted from inventory and, if so, where can I find out
how to do it? I know a little bit about macro's but not a whole lot.

Thanks for any help you can give me!

--
Gary
Visit Lucy & Gary at
www.under-1-roof.com


.


Loading