Pasting won't work like that. It has to be one contiguous area--one area with
nothing in between.

Sort your data to put all the Dalips in one spot. Then you can paste into that
area.

dalipsinghbisht wrote:

C D E
Hi,

I am still confuse with this... i am explaining my problem by the
following example:

9 Dalip Dalip Singh
10
11
12 Dalip Dalip Kumar
13
14
15
16 Singh Dalip Aryan

Now I want to paste All the Data that contains Dalip in the Coulmn E to
Coulmn C.

Note: i have to use Filter for this... how can i paste the same data
when there is a filter in Worksheet....

Thanks

--
dalipsinghbisht
------------------------------------------------------------------------
dalipsinghbisht's Profile: http://www.excelforum.com/member.php...o&userid=32557
View this thread: http://www.excelforum.com/showthread...hreadid=523516

--

Dave Peterson