Copy and paste

[williams_ash]

Hi,

I am currently trying to transfer multiple addresses from one spreadsheet to another, however when I paste I get a #ref error in the boxes when it paste to the new spreadsheet. If there a way to get around this so I don't have to manually transfer each address?

[#2]

Have you tried pasting values? When you click in the cell you want to paste into, right click and look for the icon with A.