Hy everyone,
I am fairly new to excel. I started using excel to create a overview on my stock. I wanted to create a table which would allow me ,via drop down menus, to select specifications of products and filter them out of the enormous list of products i have in stock. I figured it would be smart to start of with just 5 items in the table. it would look something like this:
REG. NR DEVICE NAME DEVICE TYPE CALIBRATED DEPARTMENT USAGE AVAILABLITY LOCATION NOTE
DS/A/1001 digital simulator YEF-SCE SIM140 no NVT none not-available sold
DS/A/1002 digital simulator YEF-SCE SIM140 no NVT none not-available sold
DS/A/1003 digital simulator YEF-SCE SIM140 no NVT none not-available sold
DS/A/1004 digital simulator YEF-SCE SIM140 yes Service CE Test Available 1A
DS/A/1005 digital simulator YEF-SCE SIM140-s yes Service CE Test Available 1A modded to distribute 24V (old, dirty)
REG. NR DEVICE NAME DEVICE TYPE CALIBRATED DEPARTMENT USAGE AVAILABLITY LOCATION
(drop down menu under every one of these specifications to select the different options)
lets say i want to see a list of all available products, i want to filter the list via a dorp down menu (right under the avialablity secition, cell G9). i select "available" in the list and it should filter out all the not-available products.
I figured that this would be achievable via hidding the tabs i need to have filtered out. (by the way, the location doens't point out a cell in excel, A1 is a storage container in real life).
so with a little bit of help from the internet, i managed to write these lines of code (which work) to achieve this.
=====================================================
===========================================
that is one specification down. next I need to be able to filter the "calibrated" tab.
that would be done with the same type of coding. but once I add both of the codes to gether, they stop working.
===========================================
=======================================
i figured that i could only have one Worksheet_Change(ByVal Target As Range). But i honstly have no idea how to work both codes in to one complet code. I can't figure out any other way of doing this either.
I have been looking for work arounds but i can't seem to get to one. I decided to go ask for help my self on these forums, i could really use the help of some of the experts on these forums.
Thanks for your time in advance, i know my english is not really good.. but i am desperate for your help.
(a attempt of mine to fix the problem)
======================================
=================================
Bookmarks