How satisfied are you with this reply? Dear Ron Thanks for prompt reply, i will be waiting for your new version. Notify me of followup comments via e-mail. Thanks so much for this — I was about to write a macro to do this myself, but thankfully I found your far more feature-laden add-in. For Each sh In mybook.


Uploader: Zululkis
Date Added: 14 February 2008
File Size: 13.93 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 84717
Price: Free* [*Free Regsitration Required]

Ron de Bruin http: Hi Ron, you have done a great job….

Before we press on the Merge button we have a few rdmerge here that you can change. Perhaps your add-in could handle this option.

See example 4 on this page http: Yes, I am sure it exists…Actually code is working for sheets with 5 coloumns but when you have 10 coluomns with gives that error. Not tested but I will soon My main machine is also a Mac now so I am trying all Windows code to see if I can get it to work in I start this problem page http: Ashish Mathur Replied on January 10, Sign up using Email and Password.


I could not modify your code as it is protected with password. I spent a lot of time on merging xml files in the past. Check out the filter example in this code example See example 4 http: By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

RDBMerge, Excel Merge Add-in for Excel for Windows

The environment I work is deluged with processes where the merging of multiple workbooks are a weekly occurance. You can use it for example to filter the Combine sheet rdbmeege the data from a certain file.

Thanks Ron, I solved it by first removing the filter, merging the sheets and applying the filter again. Hello Ron, I want to call your addin in one of my macro. Actually i want to pick specific error strings from a log file and want the data in excel file for further working.

Subscribe to RSS

Hi adprim For txt files see http: This is not a easy macro. C1″ End With If Err.


This is the command line output:. All the data is missing. You are a genious in Excel.


Best way to consolidate multiple sheets from multiple workbooks

Its an awesome tool and Thank You for sharing. Click on the Merge button: Thanks for marking this as the answer. Hi Ron, Great tool. Rdhmerge have another question, how can i modify the range of the copy and pasting of the workbooks being merged?


This thread is locked. Thanks so much for this rrbmerge I was about to write a macro to do this myself, but thankfully I found your far more feature-laden add-in. You have the option to merge a fixed range can be more than one area.


Norman David Rdbmdrge Replied on January 10, Worksheets If LCase sh. Hi Duke Send me a private mail I will send you a example workbook if I have your address.