| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to copy several nonajacent cells and paste to ajacent cells in one row
How can i copy several nonajdacent cells from Sheet2 and paste
into adjacent cells in Sheet1 row? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy several nonajacent cells and paste to ajacent cellsin one row
On May 19, 12:16*pm, Bluejay wrote:
How can i copy several nonajdacent cells from Sheet2 and paste into adjacent *cells in Sheet1 row? are all you cells listed in one particular column or row? or are they scattered throughout sheet2? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy several nonajacent cells and paste to ajacent cells in one row
one row
On Thu, 19 May 2011 12:32:01 -0700 (PDT), Matthew Dyer wrote: On May 19, 12:16*pm, Bluejay wrote: How can i copy several nonajdacent cells from Sheet2 and paste into adjacent *cells in Sheet1 row? are all you cells listed in one particular column or row? or are they scattered throughout sheet2? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy several nonajacent cells and paste to ajacent cellsin one row
On May 19, 12:50*pm, Bluejay wrote:
one row On Thu, 19 May 2011 12:32:01 -0700 (PDT), Matthew Dyer wrote: On May 19, 12:16*pm, Bluejay wrote: How can i copy several nonajdacent cells from Sheet2 and paste into adjacent *cells in Sheet1 row? are all you cells listed in one particular column or row? or are they scattered throughout sheet2?- Hide quoted text - - Show quoted text - well, if this is just something that you need to do one and don't need a macro.... 1. holding ctrl, click on the letter of all columns that are blank and contain no data 2. right click on one of the selected columns and choose 'hide' 3. assuming you're using excel 2007, in the home tab of the ribbon, select Find & Select all the way to the right, then Go To Special 4. select Visible Cells Only and click OK. This will highlight all visible cells 5. Copy 6. Paste into your other sheet. Unfortunately i do not know how to re-create this in a Macro. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy several nonajacent cells and paste to ajacent cells in one row
I'm using Excel 2003 which doesn't have that functionality. and all
columns on Sheet2 have values. no blanks. On Thu, 19 May 2011 13:10:15 -0700 (PDT), Matthew Dyer wrote: On May 19, 12:50*pm, Bluejay wrote: one row On Thu, 19 May 2011 12:32:01 -0700 (PDT), Matthew Dyer wrote: On May 19, 12:16*pm, Bluejay wrote: How can i copy several nonajdacent cells from Sheet2 and paste into adjacent *cells in Sheet1 row? are all you cells listed in one particular column or row? or are they scattered throughout sheet2?- Hide quoted text - - Show quoted text - well, if this is just something that you need to do one and don't need a macro.... 1. holding ctrl, click on the letter of all columns that are blank and contain no data 2. right click on one of the selected columns and choose 'hide' 3. assuming you're using excel 2007, in the home tab of the ribbon, select Find & Select all the way to the right, then Go To Special 4. select Visible Cells Only and click OK. This will highlight all visible cells 5. Copy 6. Paste into your other sheet. Unfortunately i do not know how to re-create this in a Macro. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy several nonajacent cells and paste to ajacent cells in one row
In one row...................select first cell then CTRL + click on remainder
one at a time. Copy. Switch to other sheet, select a single cell and Paste Gord Dibben MS Excel MVP On Thu, 19 May 2011 15:50:18 -0400, Bluejay wrote: one row On Thu, 19 May 2011 12:32:01 -0700 (PDT), Matthew Dyer wrote: On May 19, 12:16*pm, Bluejay wrote: How can i copy several nonajdacent cells from Sheet2 and paste into adjacent *cells in Sheet1 row? are all you cells listed in one particular column or row? or are they scattered throughout sheet2? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy several nonajacent cells and paste to ajacent cells in one row
2003 has that capability.
Try this............select header of column A then hold CTRL key and click on Column D header then Column H header. Copy. Switch sheets, select A1 and Paste. Gord Dibben MS Excel MVP On Thu, 19 May 2011 16:24:37 -0400, Bluejay wrote: I'm using Excel 2003 which doesn't have that functionality. and all columns on Sheet2 have values. no blanks. On Thu, 19 May 2011 13:10:15 -0700 (PDT), Matthew Dyer wrote: On May 19, 12:50*pm, Bluejay wrote: one row On Thu, 19 May 2011 12:32:01 -0700 (PDT), Matthew Dyer wrote: On May 19, 12:16*pm, Bluejay wrote: How can i copy several nonajdacent cells from Sheet2 and paste into adjacent *cells in Sheet1 row? are all you cells listed in one particular column or row? or are they scattered throughout sheet2?- Hide quoted text - - Show quoted text - well, if this is just something that you need to do one and don't need a macro.... 1. holding ctrl, click on the letter of all columns that are blank and contain no data 2. right click on one of the selected columns and choose 'hide' 3. assuming you're using excel 2007, in the home tab of the ribbon, select Find & Select all the way to the right, then Go To Special 4. select Visible Cells Only and click OK. This will highlight all visible cells 5. Copy 6. Paste into your other sheet. Unfortunately i do not know how to re-create this in a Macro. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy several nonajacent cells and paste to ajacent cells in one row
Thank you too much Matthew and Gord
On Thu, 19 May 2011 15:16:43 -0400, Bluejay wrote: How can i copy several nonajdacent cells from Sheet2 and paste into adjacent cells in Sheet1 row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highest value cell and ajacent cells | Excel Discussion (Misc queries) | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| Copy Cells/Paste Cells Programatically | Excel Programming | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
Linear Mode
