title: Using a single macro on several tables across several sheets
body: <p>I have a workbook that is split one page=one month of the year.
  on each of those sheets is a table with various conditional formatting on it.
  from there I filter the information several ways to obtain certain bits of information, (outstanding balances, items waiting for dispatch etc etc)</p>
  
  <p>I am trying to set up some simple macros to make filtering quicker, e.g show only orders from a particular company, that have been dispatched, but not paid for.</p>
  
  <p>My problem is, the macro only applies to the sheet/table I created it on, is it possible to reword the vb code to make the macro work across all sheets/tables of my work book?</p>
  
  <p>This is an example of one of the macros, sorry if there is protocol for inserting code on this forum, I plead ignorance.</p>
  
  <pre><code>Sub HSWC_only()
  '
  ' HSWC_only Macro
  ' leaves only hi-spec jobs
  '
  ' Keyboard Shortcut: Ctrl+m
  '
      ActiveSheet.ListObjects("Table25").Range.AutoFilter Field:=3, Criteria1:= _
          "=HSWC*", Operator:=xlAnd
  End Sub
  </code></pre>