title: filter data in one excel sheet based on data in another excel sheet
body: <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>