Update: Added missing ‘Sub End’
On Excel 2010, I created this VBA to copy data from a specific column on a specific table to another table on another spreadsheet to editing the values later without disturbing the original source data.
I am posting it here since I had to do multiple searches for the syntax.
'Delete current values prior to paste if values exist
If Application.WorksheetFunction.CountA(Range("Table2[Column1]")) <> 0 _
'Select desired column to copy with destination option
If you find this snippet of code useful, leave a comment.