Hi..

Is there a macro for copying filtered data from one sheet to another sheet.
Ive been surfing the internet for a few days now and i saw some macro's that
almost did the job. Ive got a lot of lines and colums so im using the filter
option a lot. The problem is that it takes to much time to copy it everytime.

What i would like is a macro that copies the filtered data to a new sheet in
the same workbook with formulas and the header. It would be good if it
selects automaticly all the filtered data when using the macro. An option is
if it asks in a popup box the name of the new sheet (that would be
perfect).... please help me with this....

Thanks