copying data w/o the formulas

L

Louie

Hi there, I need some help copying data from book to book without copying the
formulas on the cells, when I copy a column, it brings the formulas with it
and it gives me an error, is there a way to copy only the Data?
thanks for your help.
 
L

Lyndy Lou

Instead of just paste use Edit>Paste Special and choose values. This pastes
only the value and not the formula

Cheers Lyn
 
Top