| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy-maping cells from one to another workwsheet
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy-maping cells from one to another workwsheet
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| "maping" work sheets | Excel Discussion (Misc queries) | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
Hybrid Mode
