Multiple value selection in one column in a huge data through macro

[Aravindhan Bharathi]

Hi All,

I have a huge data (around 200000 rows) and upto AZ column. In the Column "R" we need to apply autofilter for selecting more than 10 values . once its selected it should be copied and paste in new workbook through VBA .

Kindly help..

 

[Aravindhan Bharathi]

Sorry rows are huge not 200000

 

[Marc L]

Hi !

Activate Macro recorder, operate manually :
you'll get your own code base !

And better is to directly use an advanced filter …

Introduction to Excel Advanced Filters
Extract data using Advanced Filter and VBA …
​