I want to know that how we can copy the data together when there is a
filter in worksheet.

I am attaching a JPG file for your considration.

there are three coulmn and three rows on which i am working. I gave a
filter to Y In coulmn D and then i want to paste the data of coulmn E
in coulmn C. that can replace all the data on the same place. i.e. i
want Ream,y in the place of Ream, shyam,y in place of shyam and btht,y
in place of btht. I want to copy all the data at the same time.

Note Please take a look on the Picture attached with this Thread.


Thanks in advance


+-------------------------------------------------------------------+
|Filename: Problem.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4481 |
+-------------------------------------------------------------------+

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