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