RE: $$Excel-Macros$$ Multiple excel files

2011-07-18 Thread Chidurala, Shrinivas
Thank a lot Anish, It is working fine. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anish Shrivastava Sent: Friday, July 15, 2011 5:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Multiple excel

Re: $$Excel-Macros$$ Multiple excel files

2011-07-15 Thread Anish Shrivastava
Hello Group, It would be an add-in for my learing, if you can suggest the code for finding unique account values from Column "A" using the code so that Shrinivas doesnt have to copy and paste the unique account values manually in cell M1. Thanks, Anish On Fri, Jul 15, 2011 at 5:27 PM, Anish Shri

Re: $$Excel-Macros$$ Multiple excel files

2011-07-15 Thread Anish Shrivastava
Hi Shrinivas, Attached please find the Dump file with macro. You will have to copy and paste your unique account numbers in Cell *"M1" *before running the macro. Data will be splitted based on the account numbers and new files will be saved with account names. Also note that I have done it with