Hi all,

I am putting 2 filters on 2 worksheets in the SAME WORKBOOK.

I would like to see if I can do something like this:

1. if I click the filter on worksheet1 and select a value, it can be passed
to the filter on worksheet2 and shown the corrensponding result on worksheet
2.

2. Vice versa, when i click the filter on worksheet 2, the same effect will
apply to worksheet 1.

FYI, the columns on each worksheet has the same format.

Thanks alot~