troubleshooting Question

More Help with Macro to copy data from multiple tabs in multiple workbooks to one spreadsheet

Avatar of DMKetcher
DMKetcherFlag for United States of America asked on
Microsoft Excel
9 Comments1 Solution376 ViewsLast Modified:
Dave (dlmille) helped me with this so maybe it would be quickest if he responded.

The solution you provided worked with a piece of what I am attempting to do. In reality I have seven tabs of data I need to move into the spreadsheet. When I originally created the macro it was too large to handle all seven tabs so I broke it into three macros and called 2 from 1, 3 from 2 etc. This worked great when working one line at a time. After I got your solution for opening multiple workbooks I applied the logic to the three macros I developed executing each one with a different control key (ctl/r, ctl/s, ctl/t). Ideally I would like to be able to execute using ctl/r and loop through all of the tabs but I thought it would take me too long to build and took the easy way out.

The problem: The Macro 1 works fine. Macro 2 and 3 are not incrementing the destination row (X = rDest.Row) consistently. I have done extensive testing and cannot find a pattern. I am attaching the code and workbook folder.

Thanks again for your expert help!
Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros