title: Editing data through a filter in Excel
body: <p>I have a large imported .csv as a (Query) table in an Excel workbook. I'd like for users of the workbook to be able to select a small subset of that data and update some values without having to play around with filters on the table.</p>
  <p>To that end, I've set up a <code>FILTER</code> on a separate sheet, something like:</p>
  <pre><code>=FILTER(my_table[some_column], my_table[id_column]=&quot;some value&quot;)
  </code></pre>
  <p>That pulls in values from the relevant column and displays them.</p>
  <p>My question: is there any way to allow users to edit the values retrieved with the <code>FILTER</code>, so that the changes are reflected in the original table? Attempting to edit such a value now just edits the underlying field, causing the <code>FILTER</code> to update and display <code>#SPILL!</code> (which makes sense, since there is not enough free space to render the result).</p>
  <p>I've looked at options for <code>FILTER</code>, and thought about writing some custom VBA code to do what <code>FILTER</code> does &quot;manually&quot;, and then watch the sheet for updates in that range - but that seems like a lot of coding to do something I would imagine is more commonly needed?</p>
  <p>Am I going to have to code this up in VBA? Or is there some alternative approach to using the <code>FILTER</code>?</p>