I received this code from a previous question
and it worked perfect for another project.
I started a new project today and it only pulls the first value, exits the loop and then I get an error when it tries to save over the same file. I have checked the formatting of the column (2) I am using for the unique values and it is the same. In stepping through the code and looking at the variables, I don't see where it is not finding the entire table to pull the records.
I attached the sample workbook to help with my question. The 2nd Row, 2nd Column has a value of "E30A" . The code should look down to the last row and then copy all "E30A" rows to a new workbook (I think it actually deletes the other rows). This way I end up with a workbook for each unique value in the 2nd column.
I just used this code for another project and it worked perfect.
Thanks for any help, Brent