| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy /past range skip cells
Hi!
How can I copy a range of cells but omit individual cells For example. I want to copy the range "A1:G1" but not "F1" and because the target already has the good data for "F1" I don't want to overwrite that particular cell. Thank you! Orlando Vazquez |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy /past range skip cells
Orlando, Save the F1 value in a Variant, paste the data, change F1 back to what it was. -- Jim Cone Portland, Oregon USA "ORLANDO VAZQUEZ" wrote in message Hi! How can I copy a range of cells but omit individual cells For example. I want to copy the range "A1:G1" but not "F1" and because the target already has the good data for "F1" I don't want to overwrite that particular cell. Thank you! Orlando Vazquez |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy /past range skip cells
Well, I kind of simplified the problem.
There are about 20 cells in the range that should stay static. And about twenty that should be overwritten. Any suggestions? Also, what does "variant" mean? -- Orlando Vazquez "Jim Cone" wrote: Orlando, Save the F1 value in a Variant, paste the data, change F1 back to what it was. -- Jim Cone Portland, Oregon USA "ORLANDO VAZQUEZ" wrote in message Hi! How can I copy a range of cells but omit individual cells For example. I want to copy the range "A1:G1" but not "F1" and because the target already has the good data for "F1" I don't want to overwrite that particular cell. Thank you! Orlando Vazquez |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy /past range skip cells
Sorry, for some unknown reason, I thought you were trying to use programming code to do the copy/paste. Variant is a Data Type used when programming Excel. I don't know of any quick manual way to do what you want. -- Jim Cone Portland, Oregon USA "ORLANDO VAZQUEZ" wrote in message Well, I kind of simplified the problem. There are about 20 cells in the range that should stay static. And about twenty that should be overwritten. Any suggestions? Also, what does "variant" mean? -- Orlando Vazquez "Jim Cone" wrote: Orlando, Save the F1 value in a Variant, paste the data, change F1 back to what it was. -- Jim Cone Portland, Oregon USA "ORLANDO VAZQUEZ" wrote in message Hi! How can I copy a range of cells but omit individual cells For example. I want to copy the range "A1:G1" but not "F1" and because the target already has the good data for "F1" I don't want to overwrite that particular cell. Thank you! Orlando Vazquez |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy range and past on another sheet | Excel Worksheet Functions | |||
| Skip column cells and copy formulas | Excel Discussion (Misc queries) | |||
| Skip cells and copy formulas | Excel Discussion (Misc queries) | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
| How do I copy cells and skip lines? | Excel Discussion (Misc queries) | |||
![ORLANDO VAZQUEZ[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
