Excel Inventory Database

Hello everyone,
I am trying to build a books database in excel sheet. i current keep my books at my home and office. Also, i transfer my books to Franchise and also to students for sale. I am trying to maintain all this, but every time i try to build a database, i get confused. Hope u can help.
my opening and closing balances for Books at office and books at home should be automatically updated.
Also attaching herewith the excel sheet.
Please help.

please....anyone?????

data provided in u r Workbook is not enough to guide you .
Plz provide Rough Data and show us u r requirement manually type in Separate sheet .

Punnam

here it is....
i want to view closing balance at my home and my office directly in table.
also i want that if i transfer some books from home to office or vice versa, the balance should get automatically reduced from closing balance of home and simultaneously be add in closing balance of office automatically..
Also, the same should happen for office too. That is, if i transfer some books from office to home, the balance of office and home should get simultaneously adjusted.

If u suggest any other format, i am ready to follow...please guide me..

is there no one?

A couple notes:

Your attached file has a few errors on it (looking for a link to a "SP Classes.xlsm").
This only has one date on it; would it be sufficient to do a SUMIFS?

Please Login or Register  to view this content.

or do you need something to track the most current date as well?

thanks for ur reply....i do need most current date ....also, how will i see balances at home and office after transferring inventory from home to office and vice versa...sorry for the error in link...