Navigate To where by you should paste the data and push Ctrl + V. Only your filtered data will look. Now, we want to in some way copy the value in the above mentioned industry cell in these blank cells. This cannot be carried out applying any copy-paste approach so http://pariwatstudio.com/2015/03/13/best-tips-for-a-successful-magazine/