Copying from one Workbook to another

  • Thread starter Thread starter Bernie Beal
  • Start date Start date
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
 
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)
 
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.
 
Back
Top