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