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

  • Thread starter Thread starter Bluejay
  • Start date Start date
B

Bluejay

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

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




- Show quoted text -
Click to expand...

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.
 
I'm using Excel 2003 which doesn't have that functionality. and all
columns on Sheet2 have values. no blanks.
 
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
 
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
 
Back
Top