How can i copy and paste data when there is a filter in the worksheet....
when i am pasting the data the Excel is not pasting that in his right place...
Note :when there is a Filter in the worksheet
How can i copy and paste data when there is a filter in the worksheet....
when i am pasting the data the Excel is not pasting that in his right place...
Note :when there is a Filter in the worksheet
If you show all the data, you'll see that the paste put all the copied cells in
a nice contiguous area--it didn't just put the data in the visible rows.
One work around is to sort your data first--put all the cells that should be
pasted into a nice contiguous area--then paste and then resort your data the way
you like.
dalipsinghbisht wrote:
>
> How can i copy and paste data when there is a filter in the
> worksheet....
> when i am pasting the data the Excel is not pasting that in his right
> place...
> Note :when there is a Filter in the worksheet
>
> --
> 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
Hi,
I am not understanding this method please tell more about this so that i can paste the data within the Filter.....
Thanks
Show all the data--no hidden rows
sort your data so that your area to be pasted is in one contiguous area
paste your data
resort your data
dalipsinghbisht wrote:
>
> Hi,
>
> I am not understanding this method please tell more about this so that
> i can paste the data within the Filter.....
>
> 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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks