title: Excel copy-paste including hidden columns
body: <p>I'm using a Excel 2016 worksheet that has a couple of columns hidden for UI reasons. I need to be able to filter out data and then copy-paste it to another sheet with hidden columns intact and showing after pasting in the destination (it will contain a longer log of similar transactions, not just one copy-paste).</p>
  <p>Adding a pic of the objective - i.e. hoping to have the hidden contents of columns B and C being pasted into the destination spreadsheet. <strong>Is this possible at all?</strong></p>
  <p><a href="https://i.stack.imgur.com/Vfp62.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Vfp62.jpg" alt="enter image description here" /></a></p>
  <p>Probably not great form to ask 2 questions in one post, however are there alternatives to performing filtering and copy-paste function to another spreadsheet manually? I.e.:</p>
  <ul>
  <li>run manual filter to clear blanks in Quantity field;</li>
  <li>make a selection</li>
  <li>do manual Ctrl+C - Ctrl+V function</li>
  </ul>
  <p>Is there a way to make it easier? Unfortunately no VBA or macro experience <strong>as of yet</strong>.</p>