Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to link filters in two different sheets? | Excel Discussion (Misc queries) | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
Filters using multiple sheets | Excel Worksheet Functions | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Link 2 sheets | Excel Worksheet Functions |