You can't paste a group of cells into individual other cells. Your options
are to either

1) Sort the list you are copying into, assuming your copy to cells have
something in common

2) Use a formula... =Sheet1!A2 or so.

"saz2369" wrote:

how can i copy cells from one worksheet and paste into selected cells that
has blank cells between them