skip rows
 

How can I drag value from A1 to B1, from A6 to B2, from A12 to B3,....etc

skip rows
 

Select the cell (or range) to copy, and Ctrl/C, then select the first
cell to be copied to, and hold the CTRL key to select other cells or
cell ranges.

Ctrl/V to complete the copy.

--

marat Wrote:
How can I drag value from A1 to B1, from A6 to B2, from A12 to
B3,....etc


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532876

skip rows
 

On second reading, did you want column B to be set with the contents of
A1, A6, A11, A16, A21 etc, (ie, every 5th cell taken to the next
column), and what of the remaining cells, do these go to column C, D, E
and F ?

--

Bryan Hessey Wrote:
Select the cell (or range) to copy, and Ctrl/C, then select the first
cell to be copied to, and hold the CTRL key to select other cells or
cell ranges.

Ctrl/V to complete the copy.

--


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532876