Issues with copy and paste of all things

[cowelka1]

Hi there, first time posting a problem on here so please be kind....

I am having a problem copying data from one file to another in Excel. This issue is unique to the destination file as when I create a new Excel document the problem does not present itself. I'm loathed to start from scratch with the file itself though due to the amount of Macro currently in use which took a fair while to develop.

If for example I copy a range of data from columns A to F, when I paste the data into the destination file, the information pasted in are the contents of columns D to I. The same thing happens when I cut and paste the data. Has anyone ever come across this issue or have any advise as to what could be causing it?

 

[cowelka1]

If you disable macros, is the copy/paste still messed up? Are you pasting values only, or everything?

Tried pasting in as values and as it is both resulting in the same issue. Just disabled the macros and the same thing happens

 

[AkaTrouble]

once copied into blank sheet in workbook if you copy and paste again from that source does error occur