filter data in one excel sheet based on data in another excel sheet
<p>I have two excel sheet.</p>

<pre><code>Sheet 1 
Dept    Dept ID
X1  1550
X2  1551
X3  1552
X4  1553
X5  1554
X6  1555

Sheet 2 
Dept ID Office
1550    Sydney
1551    Darwin
1552    Melbourne
1553    Perth
1554    Perth
1555    Perth
</code></pre>

<p>What I want is to filter data on sheet 2 based on selection of Dept in sheet 1.
Suppose I choose Dept X1 than only row in sheet 2 is shown as for Dept_id=1550.</p>

<p>I don't know much about VB script. I tried to use advance filter but couldn't figure it out.</p>

<p>Thanks in advance</p>