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.