I have an Excel workbook containing 2695 rows with information pertaining to 26 individuals. My goal is to split the workbook into 26 separate workbooks which I can then save as individual files. Not being very versed in writing code, I recorded a macro where I filterd for one individual and copy/pasted the rows into a new workbook. My obvious problem is that when I run the macro, it works for the one individual I started with as opposed to repeating for each unique value in the column I filtered. Column J in my spreadsheet contains employee numbers unique to each individual. I have been searching previous threads and cannot find an answer if there is one. Is there a criteria I can use to have the macro run for each unique value? I started with "6531" as you can see below.
Sub Macro1()
'
Selection.AutoFilter Field:=5, Criteria1:="6531"
Rows("1:2660").Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
End Sub
Thank you
Sub Macro1()
'
Selection.AutoFilter Field:=5, Criteria1:="6531"
Rows("1:2660").Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
End Sub
Thank you