How do I skip blank cells when copying over a range of cells?
 

I would like to copy a column of values that have blanks between them over to
another column and skip the blanks. The skip blanks feature in paste special
does not help this issue.

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

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