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.