Navigate To the place you would like to paste the data and push Ctrl + V. Only your filtered data will show up. Now, we want to someway copy the value in the above mentioned industry cell in these blank cells. This can not be completed employing any copy-paste system http://vildastamps.com/blog/?p=8890