title: Excel VBA - Update a metadata table
body: <p>In my Excel tool, I have a GUI-Sheet which contains a metadata table for the sheets in the workbook. This metadata table has an update button which clears the table and re-reads the metadata.
  Now, however, I have added columns, which contain information that I have entered by hand. This means I can't clear the table anymore for obvious reasons.</p>
  
  <p>Excluding these columns from the clear isn't an option since the number of sheets and therefore the desired position of the information can vary.</p>
  
  <p>The only solution I could come up with by myself was to create a temporary table, copying the hand-typed info and the corresponding sheet-names into it, clearing the table, re-reading the metadata and pasting the hand-typed info by searching for the sheet's name in the metadata table.</p>
  
  <p>I thought however, there might be a more elegant solution I just couldn't see.</p>
  
  <p>Columns 1-3 in the table shown below are added by hand</p>
  
  <p><a href="https://i.stack.imgur.com/tlH4J.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tlH4J.png" alt="The metadata table (excuse the German headers)"></a></p>