Dear Community,
I hope you all doing well. Kindly help me solving a query.
I have two Different workbooks (Sample_1 and Sample_2) with multiple sheets in each workbook, however I want a sheet (named "One") which is available in both the workbooks and are very similar but i am not finding a way to bring both workbooks via Directory tool and Union those similar sheets (i.e. "One") which I want to combine.
I have prepared two macros for the same however one of macro which Union both the similar sheets is not working, Kindly help. Many thanks.
Solved! Go to Solution.
@RajatRehria attaching the workflow and the macros
Many thanks for the solution