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?

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?

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?

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.

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.

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?

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.

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?