Multi worksheet change functions on one page.

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.
=====================================================

Please Login or Register  to view this content.

===========================================
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.
===========================================

Please Login or Register  to view this content.

=======================================
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)
======================================

Please Login or Register  to view this content.

=================================

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)