S
sunny123
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
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