When you copy the data to a new worksheet a notepad ICON will appear. After
you Paste you can select in the Notepad Paste Text Only. this will preserve
the formating in the destination sheet. Normal when you copy the Souce
formating is copied to the destination. Or you can use Paste Special and
select Values Only.

"Martin26" wrote:

using excel 2007, exporting info from web to excel fromat, from there want to
automatically copy these culmns in a different worksheet and differenrt order
of the original web format, curently I have to spent long time just to map
the layout to use the deisre cut and paste format, would like to know how can
I caopy the original download excel from the web the transfer all these
culmns to a pre-set format