View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default 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?