Copy filtered and non filtered data

[rolo]

I have a table with autofilters, and some filtered fields.

I need to copy the all data to another sheet, but it only copy filtered rows.

How can I copy and paste all data, filtered and non filtered?

Thanks a lot!

[khaos]

If you know which fields you are going to copy/paste the data to and fro. Use the Macro Recorder to Record your macro, then copy/paste the data between worksheets, set your filters etc. Stop recording the macro then View the Macro. Step Into it so that you can look at the code that has been generated. This should help you.