Hi there, I am just learning VBA and I am in need of some help. I have been trying to figure out how to merge workbooks with counterpart workbooks.
I have two folders:
a.) Submit Test Case - which contains 103 workbooks saved (each book only contains one sheet)
b.) Test Scenario Books - which contains 103 workbooks saved (each book contains multiple sheets)
Problem:
Based on two lists of workbook names, I must combine certain workbooks from folder a.) and b.) together.
For example:
Submit Test Case> 3000E.01 - Submit Amendment.xlsm (subordinate)
and
Test Scenario Books> 3009E - Amendment Process.xlsm (master)
must be merged and saved as the original master name.
Is this even possible? I have been searching all day and can't find anything that works.
Any advice would be great, thanks!
I have two folders:
a.) Submit Test Case - which contains 103 workbooks saved (each book only contains one sheet)
b.) Test Scenario Books - which contains 103 workbooks saved (each book contains multiple sheets)
Problem:
Based on two lists of workbook names, I must combine certain workbooks from folder a.) and b.) together.
For example:
Submit Test Case> 3000E.01 - Submit Amendment.xlsm (subordinate)
and
Test Scenario Books> 3009E - Amendment Process.xlsm (master)
must be merged and saved as the original master name.
Is this even possible? I have been searching all day and can't find anything that works.
Any advice would be great, thanks!