Re: excel help
Posted 12/19/2009 11:07:08 AM by Christine

You can set up tabs for each type of transaction - units purchased, units sold, etc. These tabs would keep a running total of purchases/sales.

Then have a summary tab that has the

beginning balance
+ units purchased which would be = to the total on that tab

- units sold which would = to the total from that tab

ending balance.

I am not sure if I am explaining it correctly but if you like fm me your email and I can send a sample of what I mean.

Chat Icon
Print Post      Close Window