copying data w/o the formulas
 

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.

--
Louie

copying data w/o the formulas
 

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

Cheers Lyn

"Louie" wrote:

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.

--
Louie

copying data w/o the formulas
 

thank you for your help, that will work
--
Louie


"Lyndy Lou" wrote:

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

Cheers Lyn

"Louie" wrote:

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.

--
Louie