Dear Prasad,
Please try asap utility , its free add in to excel - link is http://www.asap-utilities.com/download-asap-utilities.php you should be done with it. Reply do u still face a problem Regards, Prashant From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Prasad Gadgil Sent: Monday, September 07, 2009 8:40 PM To: prashant Cc: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: (with attachment) Merging Data of two different sheets of two different files Dear Prashant & All Group Member Thanks for showing interest to solve my problem, Attaching sample zip file containing 1. Master 1 2. Master 2 Now i wish any macro to create Final Master file. Please check for desire output file. I will be really grateful for all of you if you provide solution on this. Thanks & Regards Prasad Gadgil Cell:9819442088 On Sun, Sep 6, 2009 at 10:40 AM, prashant <pawleprash...@gmail.com> wrote: Dear Prasad, Pls send sample Regards, Prashant From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Prasad Gadgil Sent: Saturday, September 05, 2009 10:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Merging Data of two different sheets of two different files Dear All Group Members, There are two different files, now i wish to merge data from two sheets into one sheet. If any one having macro for such, then i will be really greatful to you, if you share the same. Thanks & Regards Prasad Gadgil Cell: 9819442088 --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---