Hi All, I've some data in sheet1, people have to work on this data, i've assigned the work to the concern people, now what i want a macros should be run and then new files should be created ion the same folder in the name of assigned peoples and those files should contain individual works that i've assigned in the attached file. Example there are 3 people who have to work on different states no i what i want to do is if i run a macro then 3 new files should be created in the name of people who will work on the data, and each file must contain the work assigned to them.
Thanks Deepak Kumar -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Demo.xls
Description: MS-Excel spreadsheet