how to link filters in two different sheets?
 

I am making a small project at my workplace using MS Excel 2002 and
would be highly grateful to you if you could guide me as to how I can
overcome the below problem.

I have a workbook, in which there are 2 sheets -- "Distributor
Database" & "Monthly Trade Offer".

The sheet "Distributor Database" has the following columns:

SR.NO.
DB_CODE
DB_NAME
DB_TYPE
DEPOT_CODE
ASE_CODE
DSO_CODE
DIVISION_CODE
DISTRICT_CODE
TOWN_CODE
ADDRESS

and 377 rows.

The sheet "Monthly Trade Offer" has the following columns:

DB_CODE
AL-ORG-250-JR
AL-ORG-165-PH
AL-ORG-60-PH
AL-STICK-252-BX
AL-ORG-7-PH

and again the same 377 rows.

What I am trying to accomplish is that once I filter DB_CODES w.r.t.
assuming DB_TYPE in sheet "Distributor Database", I want the filtered
block of DB_CODES to show up in the sheet "Monthly Trade Offer" in
addition to being shown in sheet "Distributor Database". So basically
I want to run my filter once in the sheet "Distributor Database" but
want the result to appear also in the sheet "Monthly Trade Offer" as
if that too was filtered.

I want that everytime i filter DB_CODES in sheet "Distributor
Database" using autofilter, the DB_CODES in sheet "Monthly Trade
Offer" are also filtered to show the same block of filtered rows in
both the sheets.

I hope I am clear in my problem description.

I am really looking forward to your answer.

Regards,