Copying from one Workbook to another

[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

 

[hybridthinker]

check and see if the workbook is protected.

 

[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)

 

[hybridthinker]

check and see if the workbook is protected.

 

[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.