This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.