Forum Discussion
Copying/Paste Filtered Cells
2023 and Microsoft can't figure out an easier way to copy and paste filtered cells.
Excel does not provide a direct method for copying and pasting from visible cells to visible cells. So here's a method using VBA. Please check out this article:
https://www.mrexcel.com/board/excel-articles/excel-vba-easy-way-to-paste-to-visible-cells.70/
And you can put the code in PERSONAL.xlsb and assign a toolbar button to it. The benefit of doing it this way:
The macro is available on any open workbook & easy to access (i.e. via a ribbon button)
You don’t need to put the macro on all your workbooks, just on PERSONAL.xlsb.