how to link filters in two different sheets?
 

Dear All,

I have two excel sheets. on sheet 1 i have the following data:

DB_Code DB_Type DB_DISC

111 1 234
222 2 232
333 3 3343

on sheet 2 I have the following data:

DB_Code XXX YYY

111 34 21
222 23 234
333 43 5435

Now, what i want to be able to do is the following, when i filter
sheet 1 by lets say column DB_Type, I get a selection of DB_Codes.
(Assuming i filter DB_Type by 1, I will get the row with DB_Code 111).

Now i want that in sheet 2 where again i have DB_Code, only row with
Db_code 111, should be selected..as if it was filtered and the outcome
of the filter in sheet 1 is actually reflected in sheet 2..

THank you so much for your help.

Regards,
Sunny