Feb 16 2023 03:04 PM
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?
Thanks
Doug
Feb 17 2023 12:16 AM
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
Feb 20 2023 05:48 PM
Thanks for the help. I'll give it a try.