macro to copy data to other sheet
Hi,
It would help if you could give a small example of you arre trying to do.
Post a workbook and I'll take a look.
"TooN" wrote in message
...
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
|