Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems With a Searchable Inventory Worksheet
I have tried looking in past entries and in excel help but I cant seem to
find the answers I am looking for. This is what I am trying to accomplish. I am trying to put together a searchable tool inventory. There are over 200 boxes of tools and many tools inside each box. I would like to put the tool# that I am searching for in cells B3-B12 and have the box# that the tool is in show up in C3-C12. Now here is another problem. I also would like to be able to click on the box# in C3-C12 and have it open up to the RIGHT like a drop box so I can see all of the tools in that box. 1 A B C D E F 2 TOOL# BOX# 3 Search for tool # 4 Search for tool # 5 Search for tool # 6 Search for tool # 7 Search for tool # 8 Search for tool # 9 Search for tool # 10 Search for tool # 11 Search for tool # 12 Search for tool # 13 tool# tool# tool# 14 BOX 1 t1 t2 t3 15 BOX 2 t4 t5 t6 16 BOX 3 t7 t8 t9 17 BOX 4 t10 t11 t12 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3D reference question in inventory Worksheet | Excel Worksheet Functions | |||
I am looking for an excell worksheet for restaurant inventory | Charts and Charting in Excel | |||
Creating an inventory worksheet | Excel Discussion (Misc queries) | |||
how do i set up a worksheet to calculate the inventory? | Excel Worksheet Functions | |||
Searchable Database | Excel Worksheet Functions |