troubleshooting Question

Copy Data from Two Workbooks and Paste to Create New Workbook ( Macro ? )

Avatar of justearth
justearthFlag for United States of America asked on
Microsoft ExcelScripting LanguagesVisual Basic Classic
4 Comments2 Solutions456 ViewsLast Modified:
Hello,
I have directory with workbooks with names like:

corr.all.o
corr.selection.o
corr.random.o
&
corr.all.r
corr.selection.r
corr.random.r

They have the same layouts.  I'd like to copy the data from the 'Group Matricies' Sheet from each pair (i.e. corr.all.o and corr.all.r) and paste them side by side in a new workbook (i.e. corr.all).  Can this be done with a macro? For all pairs in a directory?

I have attached examples.

Thank you,
Cheers,
JE
je-ee-combine-corr.xlsx
corr.all.r.xlsx
corr.all.o.xlsx
ASKER CERTIFIED SOLUTION
DharamV
Director - Technology

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 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 2 Answers and 4 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