Hi everyone
What I would like to achieve is to save an existing list, in individual files.
The list contains "open cases", which are each assigned to an employee.
The list is sorted by the name of the employee (col. b).
Headers are from row 1 to 3 (allthough I could change that if necessary)
How would I achieve that it saves an individual file, for each employee in the list?
Ideally the file name would contain the employees name.
Thanks a lot for any help provided
FD
can you attach a sample file and also a sample result file ?
If solved remember to mark Thread as solved
Hi
Please see attached
Sample.zip
Output File Names should be = the Exmployees Name
Your sample files dont match your explanation in post 1.
In post 1 you mention that the employee names will be in column B but your sample files have them in col A. Also your header is just 1 row v/s 3 rows that you mentioned earlier. If your sample files do not match the original files with regard to format, there could be double work to change the code again to match the original file.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
this code uses Sheet 2 as service sheet
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks