Ron,
This is difficult to do when I have a whole spreadsheet of data and don't
want to screw anything else up, right idea though. thanks

"Ron Coderre" wrote:

If you mean that you want to copy a column of cells, but omit the blank cells
(as if they don't exist), try this:

1)Autofilter the range......DataFilterAutofilter
2)Set the column filter to be Non-Blanks
3)Copy the range, then paste it where you want it
The blank cells will be left behind.

Example:
A1: Amount
A2: 50
A3: (blank)
A4: 55

Using my suggestion, would A1:A4 would copy/paste as this

A10: Amount
A11: 50
A12: 55

Is that what you meant?

--
Regards,
Ron