Basic Inventory Database in Excel

[mmm1199]

Hi,

I am thinking to build a simple inventory database for my company (a SME) as I can't afford the inventory management system.

I would like to generate a monthly inventory report based on the entries in master list (worksheet name:"inventory movement record").

However, I have no idea to link up the data between 2 worksheets.

Here is the file link -->> http://www.dropbox.com/s/mshynznpqyu9tg5/Inventory Report.xlsx?dl=0

Gratefully appreciate for your generous help!

 

[pmich]

No file is in the link you have given. If you can post what data you have and what output you expect, then some experts will give you suggestions.