如何将可见单元格(过滤后的表单元格)复制粘贴到CSV中

I want to copy and paste from one excel to another using copy and paste visible cells only as I have a filtered table between a set range.I want to copy and paste from one excel to anot