I am trying to create an inventory system that tracks products by Lot Number.
I currently have 2 worksheets: one with inventory balances and one
transaction page. I would like to be able to only input inventory changes on
the transaction page and be able to see the updated balances on the balance
sheet pages. The balance changes would correspond to item Lot Number so that
when the lot number is typed into the transaction page, the balance page will
be updated with the amount added or removed.

I know this can be done because I've done it before, but it's been so long
since I've had to start from scratch. Can someone help me out?

Thanks!