title: Automatically Update Data in Other Excel Sheets of a Workbook
body: <p>I have VBA code that takes my data on the "master" worksheet and puts it in the other sheets in a workbook. The problem I am having is that the new data doesn't update automatically. I would like to develop code that will automatically update my worksheets. This is the code that I have now. </p>
  
  <pre><code>Sub test()
  Dim LR As Long, i As Long
  LR = Range("A" &amp; Rows.Count).End(xlUp).Row
  For i = 2 To LR
  If Range("B" &amp; i).Value = "AP" Then Rows(i).Copy Destination:=Sheets("AP").Range("A" &amp; Rows.Count).End(xlUp).Offset(1)
  If Range("B" &amp; i).Value = "*AP" Then Rows(i).Copy Destination:=Sheets(" If Range("B" &amp; i).Value = "CSW" Then Rows(i).Copy Destination:=Sheets("CSW").Range("A" &amp; Rows.Count).End(xlUp).Offset(1)
  If Range("B" &amp; i).Value = "CO" Then Rows(i).Copy Destination:=Sheets("CO").Range("A" &amp; Rows.Count).End(xlUp).Offset(1)
  If Range("B" &amp; i).Value = "PSR" Then Rows(i).Copy Destination:=Sheets("PSR").Range("A" &amp; Rows.Count).End(xlUp).Offset(1)
  Next i
  End Sub
  </code></pre>
  
  <p>This puts the data in the other sheets, but when I input new data into the "master" worksheet, the data does not update in the other sheets. I've tried other methods to include auto filter, but they haven't worked.</p>