Excel Export Order Confirmation

General information
Source File name: "Client Confirmation Processing"
The tab “Ausgabe AB Home Delivery Export” in the source file is already automatically filled by the contents of the “Ausgabe AB Home Delivery” tab.
Target file "HD Auftragsbestätigung Lieferantenlogistik“
VBA export in the source file, exports automatically the content from the source file "Client Confirmation Processing" , tab “Ausgabe AB Home Delivery Export” into the target file "HD Auftragsbestätigung Lieferantenlogistik"

Task 1:
Create macro command button:
- Tab: „Ausgabe AB Home Delivery“
- top left corner in cell A1 on top of Order number
- Command button name: „Export“

Task 2:
Create a new tab “Config”
- In this tab allow us to add manually the path and file name of the target file used by the macro. This will allow us to rename the target file if needed.

Task 3:
When the export button is pressed, then:
- Transfer the whole content (the entire sheet) from tab "Ausgabe AB Home Delivery Export" to the target file "HD Auftragsbestätigung Lieferantenlogistik"
- All Input in the source file shall be exported to the target file as content but not as formulas
- Formatting and conditional formatting in the source file should remain unchanged

Additional Information:
- The complete form (content) has to be transferred, not just individual cells. As a result, if the customer makes changes to the target file, we can simply change these changes 1:1 in the source file without changing the macro itself.
- We will later hide the tab “Ausgabe AB Home Delivery Export” in the source source file “Client Confirmation Processing”. The macro must also work well if this source is hidden.

Attachments:
Client Confirmation Processing
HD Auftragsbestätigung Lieferantenlogistik