:thumbsup:

OK, if I understand what you are trying to do, you are only wanting to copy the non-blank cells.

Select the range you want to copy and then use the Select Option and click on Constants. This will...

I would have to see an actual spreadsheet with the cells and some explanation of what you are trying to do. Post a link or screenshot. There are always more ways than one to achieve something.

Excel usually recognises patterns in data and fills the cells accordingly. Make sure you select more than one cell before you start dragging from the bottom corner to extend the column so that Excel...

Its probably because I did not fully understand what you were trying to do. I guessed you were trying to copy from several individual cells and paste into a new region of the worksheet. When you do...

Try the option of pasting as a link instead of pasting formulas.