Can someone help me with this? I need to take large files, which are sorted by area and split the rows for each area into individual workbooks.
Area City Dollars
AL Bham 5
AL Mnt 10
AL Hunt 5
TN Nash 6
TN Memphis 5
This would produce two workbooks, Alabama with three rows and a header and TN with two rows and a header.
Trisha
padinka@yahoo.com
Area City Dollars
AL Bham 5
AL Mnt 10
AL Hunt 5
TN Nash 6
TN Memphis 5
This would produce two workbooks, Alabama with three rows and a header and TN with two rows and a header.
Trisha
padinka@yahoo.com