|
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. |