title: Excel Worksheet Change VBA to update formula range in a worksheet for changing input data
body: <p>I have found this answer on SO that is close to what I want to do, but my knowledge of VBA is too basic to modify for my specific situation. </p>
  
  <p><a href="https://stackoverflow.com/questions/5498065/automatically-copy-formulas-as-data-expands">Automatically copy formulas as data expands</a></p>
  
  <p>The difference in my case is that the data my formulas refer to is not the entire previous worksheet. For example, I want my formulas in sheet "B" to use data from sheet "A" that corresponds to those rows containing cells with string "XYZ." Sheet "A" is linked to a data source that updates regularly, changing the number of rows containing said string. As "A" updates, "B" calculates what it needs to, then is plotted automatically (which I already have a sub for), but I cannot figure out how to automatically make the range of formulas reflect the fluctuating range of data. </p>
  
  <p>Any ideas?</p>