title: Apply filter from a master worksheet to multiple worksheets
body: <p>I am trying to apply filter from a master worksheet to multiple worksheets in the same workbook.</p>
  
  <p>eg.</p>
  
  <p>There are 3 worksheets in the workbook, with following fields on each sheet:</p>
  
  <ol>
  <li>Country</li>
  </ol>
  
  <p>CountryCode, CountryName</p>
  
  <ol>
  <li>Sales</li>
  </ol>
  
  <p>CountryCode, SalesAmount</p>
  
  <ol>
  <li>Inventory</li>
  </ol>
  
  <p>CountryCode, InvAmount</p>
  
  <p>When i filter Country sheet by FRA, JPN, and USA, i expect Sales and Inventory sheets will follow the same filter criteria automatically, and display only FRA, JPN, and USA rows.</p>
  
  <p>It doesn't seems to be too complicated, but i have been trying to code in VBA using AdvancedFilter method, for a few days with no luck! </p>
  
  <p>Many thanks for your help!</p>