Navigate To where you should paste the data and push Ctrl + V. Only your filtered data will seem. Now, we want to someway copy the value in the above subject cell in these blank cells. This can not be completed working with any copy-paste approach so we must use https://blog.quriusolutions.com/?p=458