I'm want to use MS Excel to keep track of inventory and sales in a small home-based business.
Would it be possible to set up something in Excel so that when I entered a sale on one worksheet 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.
Excel gurus please help...
Thanks in advance
(e-mail address removed)
Would it be possible to set up something in Excel so that when I entered a sale on one worksheet 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.
Excel gurus please help...
Thanks in advance
(e-mail address removed)