How to Paste Visible cells only
This is the easy way to Paste data in visible cells or filtered cells. Easy to download macro file.
Follow instruction mention below
First copy the paste2visible.xlam file. (Download link at the Bottom of the page.)
Open Excel blank workbook then Goto File->Options
Select Add-Ins then click on "Go"
then Select Browse
Paste here that you copy previously (paste2visible.xlam) then click on "OK".
Select "OK".
Now you will see a new command 'PasteVisible' added in Home Tab.
Enjoy pasting
If this post help you then comments below.
