Below is a piece of the code that I am using. I am trying to run thru a list of cells and use each one as the criteria for autofilter. The first one is in "N7". The next would be in "N8". How can I change this code to loop thru the entire code for each cell stopping when the next cell in column N is blank???
Selection.AutoFilter Field:=1, Criteria1:=Range("N7")
Range("A1:L1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Workbooks.Add
Selection.AutoFilter Field:=1, Criteria1:=Range("N7")
Range("A1:L1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Workbooks.Add