How to copy several nonajacent cells and paste to ajacent cells in one row

[Bluejay]

How can i copy several nonajdacent cells from Sheet2 and paste
into adjacent cells in Sheet1 row?

 

[Matthew Dyer]

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?

 

[Bluejay]

one row

are all you cells listed in one particular column or row? or are they
scattered throughout sheet2?

 

[Matthew Dyer]

one row




- 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.

 

[Bluejay]

I'm using Excel 2003 which doesn't have that functionality. and all
columns on Sheet2 have values. no blanks.

 

[Gord Dibben]

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

 

[Gord Dibben]

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

 

[Bluejay]

Thank you too much Matthew and Gord