Copy and paste

Occasional Visitor

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?

1 Reply
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.