Extract all rows from a range that meet criteria in one column in excel using Excel VBA

Extract all rows from a range that meet criteria in one column in excel

Let’s Assume you have bunch of data like this, it’s about used range 4395 rows, in column “A” 

there are category’s like (SOUTH,NORTH,EAST,WEST) wise sales happened in particular month,

Value’s In sheet1

So now what if you want to copy only SOUTH and NORTH in a single click..??

Yes its possible..let’s go to the example.

Example:

We have 3 sheets in a workbook sheet1 for dump,  sheet3  for Assign Macro button and  paste matching value’s in column A & B,

Sheet3

As looks like in above screen shot once you click the command button,  A1, A2 and A3  matching Zonal data’s from sheet1 should copy AND paste into sheet3,

Explanation: As we assigned VBA to copy sheet1 dump which are Matching in Sheet3 Range G1:G3 Value.

For your easy Understanding Please Click Here to download the Example sheet.