PQ Run-time error '1004': [Expression.Error] The Column 'Column2' of the table wasn't found.

Hi Belinea ,
Based on your description, I checked the documentation for the issue in question and the reason that caused Run-time error '1004': [Expression.Error] The Column 'Column2' of the table wasn't found to occur could be due to the VBA code referencing a non-existent range or the VBA code referencing a misspelled or non-existent named range.
You can refer to the following documents, which give more details about the cause and possible workarounds.

VBA Excel - Run-time Error '1004' when trying to assign a value to a Cell - Stack Overflow
date - VBA Excel - Compile Error Object Required - Stack Overflow

Excel VBA Runtime Error 1004 - How to Fix! (spreadsheetplanet.com)

[Solved]: How to Fix Excel “Run-Time Error 1004” in Minutes | Geekflare

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly