Forum Discussion
Copy specific data from sheet1 to sheet2
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...
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 = 3Thanks for the help. I'll give it a try.
