Copying from one Workbook to another

B

Bernie Beal

I have two similar Workbooks. How do I copy the data from one column in one
of the workbooks to a column in the other. For some reason, cut and paste
doesn't work.

Bernie Beal
 
P

Peo Sjoblom

What do you mean? You can't copy or you get a result you didn't expect? If
there are formulas involved and you want to keep the original references,
select the column, do edit>replace and replace the equal sign = with
lets say r=, cut/copy the column, paste it into the new column, now reverse
the replace and replace r= with =
Also look at the possibility to move the whole sheet (right click sheet tab
and select move)
 
D

dknight15

If the cells you are attempting to copy contain formulas, copy and paste
will copy the formulas - not the results. I suggest you link the
corresponding cell in the new worksheet to the old sheet.
 
Top