looking to be able to search and update data base for inventory control

[cocataro]

Hello,


I am looking for some help on a project. I have been given the task of inventory and control and i barely know how to turn on a computer let alone do code. I need to be able to search and update a inventory database without looking through 1000's of cells. I work in a office with close to 3000 computers and need to be able to pull up information on a single user and see what equipment they have and update it if needed. I cannot not seem to figure out how to break it up into floors (Like when I put in the employee is on the 2nd floor is there a way to put that info into a seperate spreadsheet then say someone on the 3rd floor) and still search by user or machine name.

I have a simple speadsheet and userform but I am new to all this VBA and really need some help with this.

any help would be great

Thanks in advance

Denver+Inv.xlsm

[jaslake]

Hi cocataro

Welcome to the FORUM!!

This is no small project you've undertaken. One of my favorite tools to use for this type of "database" effort (the J & R Database Form) is available free here
http://excel-it.com/vba_examples.htm

I've modified the code from this link to search on several different search criteria so, I believe, it'll suit your needs.

The code can/will allow you to search based on your criteria. Having found your target item/person/floor you can modify it if you so choose.
The code can/will allow you to add new items if you so choose.
The code can/will allow you to delete items if you so choose.

I'd recommend you place ALL your data in 1 worksheet...call it what you will "DATA" if you so choose. You don't need to break it up into floors. You can/will be able to SEARCH by floor if you wish.

Take a look at the available Download. I highly recommend it...if you need help adapting let me know.

[cocataro]

Thanks so much this will help alot!