title: Excel VBA How to detect if something was pasted in a Worksheet
body: <p>I'll start by saying that my experience with Excel and VBA is limited to what I saw in school. I have programming experience, but in other languages.</p>
  
  <p>I have a file that I get every week. The structure of this file is always the same:
  ID, Name, Date, Value between 1 and 4, non-relevant data.</p>
  
  <p>This data is selected through the 'select all' button (top left corner of the worksheet, little triangle below the cellname in MS excel 2013) and then copied into another default file that reworks the data to show and filter it in different sheets based on the 1-4 value and the date.</p>
  
  <p><strong>My question:</strong> How do I detect when data has/is being pasted? I've tried the Worksheet.Change event, but the paste command (CTRL+V) does not trigger the Change event.
  Also, how will the data be copied? Will it update Row by row, cell by cell (which direction), ...?
  I know I can easily find the answer to the last question by debugging it once I can detect the copy command, but you never know if someone knows the answer.</p>
  
  <p>Is there another, more easy (or better) way to do this?</p>
  
  <p>More data and information can be given if needed.</p>
  
  <p>Thank you for your help.</p>
  
  <p>EDIT: '...has/is being copied?' changed to pasted as it should've been.</p>