http://www.excelcampus.com/newsletter
Use this simple keyboard shortcut to select the visible cells only when copying and pasting a range with hidden rows or columns or filtered data.
Windows: Alt+;
Mac: Cmd+Shift+Z
The following video explains a few tricks for pasting to the visible cells when the range contains hidden rows or columns. https://www.youtube.com/watch?v=mrDhkClPXEM

Here is the article where I explain this technique in more detail. https://www.excelcampus.com/keyboard-shortcuts/copy-paste-select-visible-cells/