If You select numerous cells that aren't adjacent to each other, therefore you copy these cells, you’ll see a prompt as proven below. Now, we want to somehow copy the worth in the above area cell in these blank cells. This cannot be completed making use of any copy-paste approach http://www.chenyinbo.com/?p=105