Inventory Management By Excel (Urgent Requirement)

[Badrinarayan]

Can any body help me with building an Inventory Management System By Excel

My requirment is This:

I have 2000 components as Inventory

Now, My work Book will have 3 Sheets:
SHEET 1 : Input Form
SHEET 2 : DAILY USAGE SUMMARY
SHEET 3 : INVENTORY DATABASE

Sheet 1 : Sheet 1 will look like This:

Sr.No PartNo: Description Inward Outward Date
1 00001 5th March
2 00002 5th March
3 00222 5th March
4 00180 5th March

SUBMIT BUTTON

Once i enter the data in this form and click on submit Button. It should get saved in Sheet 2 (Daily Usage Summary) in the same format.

Now when I enter the Data in Sheet 1 on the Next Day i.e 6th March and click on the submit Button, It should appear in Sheet 2 from the next row of the last entry from the previous day.

Also whenever i click on the submit Button, then Sheet 3 should automatically get updated. I.e the quantities of the respective component should change everytime i Submit.

Sheet 3 will look like this:

Sr Part Part Location Opening Inward Outward Actual Stock
No: No: Name stock in Hand


Can Anybody Help??? Please It is Urgent

Thank You

 

[c_m_s_jr]

Have you considered building an Access database?