vba - Copy 2 specific sheets into a new workbook with Excel Macros

Question

I am new in Excel Macros, Can anyone help me with this issue: I need to create Excel Macro which copies data of two specific sheets with range (D1:D10) for both of them for ex. A & B of workbook Test. This data needs to be in one sheet in a new workbook with another path like Documentas/TempFile. The range (D1:D10) from sheet A needs to be in column A and data from sheet B in column B of the new created TempFile.

question from:https://stackoverflow.com/questions/65903140/copy-2-specific-sheets-into-a-new-workbook-with-excel-macros

Answer 1

Waitting for answers