Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy on filtered list
Hi,
I have been trying to copy data on a filtered list. However, it does not seem to be working. I have even tried copying on 'visibsle cells only' but that also is not working. Any solution? Regards, Vinaya. |
#2
|
|||
|
|||
Hi
what happens exactly and what are you doing exactly? "Vinaya" wrote: Hi, I have been trying to copy data on a filtered list. However, it does not seem to be working. I have even tried copying on 'visibsle cells only' but that also is not working. Any solution? Regards, Vinaya. |
#3
|
|||
|
|||
I filtered out data for a particular customer. Now when I tried changing this data by copying over it( data which is in the same format as the filtered list), it copies the data as if the data hasnt been filtered. It copies over even those data which are hidden. Hope that not confusing! Frank Kabel wrote: Hi what happens exactly and what are you doing exactly? "Vinaya" wrote: Hi, I have been trying to copy data on a filtered list. However, it does not seem to be working. I have even tried copying on 'visibsle cells only' but that also is not working. Any solution? Regards, Vinaya. |
#4
|
|||
|
|||
Perhaps you can try:
1) Edit - Copy (or Ctrl+C) 2) Edit - Paste Special - Value Hope this helps. John "Vinaya" wrote in message ... I filtered out data for a particular customer. Now when I tried changing this data by copying over it( data which is in the same format as the filtered list), it copies the data as if the data hasnt been filtered. It copies over even those data which are hidden. Hope that not confusing! Frank Kabel wrote: Hi what happens exactly and what are you doing exactly? "Vinaya" wrote: Hi, I have been trying to copy data on a filtered list. However, it does not seem to be working. I have even tried copying on 'visibsle cells only' but that also is not working. Any solution? Regards, Vinaya. |
#5
|
|||
|
|||
Vinaya
You cannot copy onto visible cells of a filtered list. You could copy the visible cells to a new sheet then copy your editing changes on top of that. Gord Dibben Excel MVP On Wed, 10 Nov 2004 16:44:04 +0530, Vinaya wrote: I filtered out data for a particular customer. Now when I tried changing this data by copying over it( data which is in the same format as the filtered list), it copies the data as if the data hasnt been filtered. It copies over even those data which are hidden. Hope that not confusing! Frank Kabel wrote: Hi what happens exactly and what are you doing exactly? "Vinaya" wrote: Hi, I have been trying to copy data on a filtered list. However, it does not seem to be working. I have even tried copying on 'visibsle cells only' but that also is not working. Any solution? Regards, Vinaya. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct on filtered cells | Excel Worksheet Functions | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Does anyone have a copy of the Peter Noneley: Function list? | New Users to Excel | |||
Creating a list from an existing list. | Excel Worksheet Functions |