Copy specific data from sheet1 to sheet2

Question

Sheet1 has list of addresses about 1000 lines long as shown in sampleCol 1&nbsp; &nbsp; Col 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Coll 3123&nbsp; &nbsp; &nbsp; Street Name&nbsp; &nbsp; &nbsp;NW456&nbsp; &nbsp; &nbsp; Another Name&nbsp; NEI want to select all the lines with NW and paste into new sheet named NorthWest and all&nbsp; the lines with NE into a sheet named NorthEast.&nbsp; Same for SW and SE.How can I do this?ThanksDoug

hansvogelaar · Answer

RetiredOldFart&nbsp;
See Create a new sheet for all Unique values&nbsp;
Since your regions are in column C, change the line
    FieldNum = 1

in the code to
    FieldNum = 3

retiredoldfart · Answer

HansVogelaar&nbsp;Thanks for the help.&nbsp; I'll give it a try.

Forum Discussion

Copy specific data from sheet1 to sheet2

Share

Resources