Copy specific data from sheet1 to sheet2

Copper Contributor

Sheet1 has list of addresses about 1000 lines long as shown in sample

Col 1    Col 2               Coll 3

123      Street Name     NW

456      Another Name  NE

I want to select all the lines with NW and paste into new sheet named NorthWest and all  the lines with NE into a sheet named NorthEast.  Same for SW and SE.

How can I do this?



2 Replies


See Create a new sheet for all Unique values 

Since your regions are in column C, change the line

    FieldNum = 1

in the code to

    FieldNum = 3

@Hans Vogelaar 

Thanks for the help.  I'll give it a try.