I have 2 Excel Workbooks, A and B.
Workbook A.xls has 2 worksheets, Sheet1 and Sheet2.
Workbook B.xls also has Sheet1 and Sheet2.
Without opening the workbooks, I would like to delete Sheet2 in A.xls, and replace it with Sheet2 from B.xls. It is something that I need to do quite a lot, hence the need to cut out the opening of the workbooks!
Asked by ZakS
(315 rep)
Apr 9, 2019, 12:45 PM
Last activity: Apr 10, 2019, 10:25 PM
Last activity: Apr 10, 2019, 10:25 PM