VBA script help

Implement a function that, upon clicking the "Export" button, creates a new sheet in the workbook and populates it with the article numbers and corresponding quantities from the Data sheet range. The information should be presented in a columnar format without any empty rows.

Develop a feature that generates a new worksheet containing the article numbers and their respective quantities, extracted from the Data sheet range, when the "Export" button is clicked. The data should be organized in a tidy, column-based layout, devoid of any gaps between rows.

Create an Export button that activates a script capable of producing a fresh spreadsheet, filled with the article numbers and corresponding quantities retrieved from the Data sheet field. The data should be arranged in a vertical, column-style format, with no blank rows or other irregularities.

want to copy data on first sheet to another sheet
select cells on columns AB, AC, AE and AF
export selected sells to the new sheet called new Data sheet
list the selected cells and export them
AB and AE refers to articles
AC and AF refers to quantity

Please Login or Register  to view this content.

no, its not just started learning vba because i found out its important for me to use excel better
was just explaining what i want to do exactly