When you have copied your data, just paste normally first time round
ignoring any errors, then paste again using paste special as values.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Dave Breitenbach" wrote in
message ...
Highlight the columns where the report is included and then copy paste
all.
The column widths etc. should remain intact.

"Debbie" wrote:

Thanks for your reply Carole, but not exactly sure what you mean. I've
tried
the Paste Special but I can only choose one option either 'format' or
'value'
I usually leave it at the default which is 'all' but I loose formats
such as
column width, wrap, etc.

"Carole O" wrote:

Debbie -

Have you tried Copy, Edit, Paste Special, and select Value and Number
formats ?

HTH,
Carole O

"Debbie" wrote:

Hi, it's really annoying when you have a nicely formated report and
then you
copy and paste it to another workbook and you loose the formatting.
Is there
any way to avoid this?