Hello all,
I have been racking my brain pretty hard trying to figure this one out - I'm definitely an excel rookie.
Basically what I have is a spreadsheet with three columns that the business I work for uses to track our tool inventory. The three columns are: Tool Description, Serial #, and job number. When a tool is checked out to a job site, the appropriate job # is placed next to each tool.
What I would like to do is have a separate sheet where I can type in the job # and have it populate a list of all tools currently assigned to that particular job.
I appreciate any advice you all can give me!
Thank you,
Chris
Bookmarks