copying a fltred list

[planiolro]

Dear all,

I have a filtred list and I want to copy it to another workbook filtered. Now I have tried both Crtl +C and Ctrl +V or click in the right mouse and choose copy and then paste it to the new workbook and it doesn t work. In both ways I am getting the same result.
What can I do about it.

 

[ganeshpoojary05]

I guess you want to copy the filtered data only the cells which are visible.

Follow the below steps:
1. Select your data,
2. Press Alt + ;
3. Then Copy ( Ctrl + C )
4. Then Paste ( Ctrl + V )

 

[stirlsa]

that doesn't seem to work...

 

[Livin_target]

Have you tried using the context menu .. copy .. then do paste special .. select values. This should do it for you.