Excell 2007 Paste Special Formatting
 

I am using Excel 2007 and want to break up a large worksheet into many small
sheets but retain the original data in one sheet. When pasting the coipied
data as a link the copied data is inserted into the new worksheet but sans
the original formating such as currency, number formats, text color etc.
What to do? ))
many thanks

Excell 2007 Paste Special Formatting
 

see response to your other posting

--
Regards
Roger Govier



"garwil" wrote in message
...
I am using Excel 2007 and want to break up a large worksheet into many
small
sheets but retain the original data in one sheet. When pasting the coipied
data as a link the copied data is inserted into the new worksheet but sans
the original formating such as currency, number formats, text color etc.
What to do? ))
many thanks