Hi All,
I have a workbook with a very large list of data. I need to Autofilter data in the database based on a criterion in the other sheet. Then I need to copy the filtered data into a new sheet.
I have the code, but it is very weak as it is purely from the recorded macros.

Please suggest how can I make this code more efficient.

Please Login or Register  to view this content.
There is also one problem.

whenever I change the code


Please Login or Register  to view this content.
to
Please Login or Register  to view this content.
there is an error. any suggestions how I can improve upon this?