Inventory System Needed!

[ProMonkey]

Hello,

im working on a excel documemnt file below.

http://rapidshare.com/files/206431695/stock.xlsx.html

i have about 6 excel files one for cd's , tvs, tapes ect and i wont to be able to search thro them all without having to open eatch of them.

also i wont to be able to search thro the document without having to press ctrl F ( im trying to make it idiot proof ) and any other features i could add to it so that it will make booking stock in and out very easy :D

i would be happy to pay for the service is somone can make or maybe even have a ready made stock list like this :D


Thanks
Luke

 

[crimson_b1ade]

I would recommend not using Excel at all. Microsoft Access would be better suited to achieve your goal. It also has a pretty good sample database "Northwind Traders" which has sample inventory, customer, supplier, shipper lists that you could tailor to your needs.