copy-maping cells from one to another workwsheet

M

Martin26

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
 
J

Joel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cannot copy worksheet to another file 2
Copying template from one worksheet to another 2
copy formulas from one worksheet to an entirely different workshee 2
Transferring files from a MAC 1
Excel worksheet moved all data from multipl cells into one 1
copy 1
Copy data from unlocked cells 3

Top