Question: how to copy and paste filtered data in excel using vba?
Answer: Open an Excel Workbook.
Press Alt+F11 to open VBA Editor.
Go to Insert Menu >> Module.
In the module, paste the below program.
Save the file as Macro Enabled Workbook (xlsm) or Excel 97-2003 Workbook (xls)