Results 1 to 3 of 3

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

Threaded View

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    denver
    MS-Off Ver
    Excel 2003
    Posts
    2

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

    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
    Last edited by cocataro; 08-31-2012 at 10:09 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1