If you want to remove the blank rows without filtering.

F5SpecialBlanksOK

EditDeleteEntire Row


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 10:11:01 -0800, Copy filtered column data & shift row up
<Copy filtered column data & shift row wrote:

I have a column of numbers which contain blank rows in between the numbers.
The blanks are in no partcular interval meaning there can be 2 blanks, 3
blanks or 10 blanks or greater between numbers.
What I am trying to do is to filter the data by numbers only (done) & copy
these numbers & paste it into another column within the same sheet by
shifting the entire data by one row up.
The pasted columns should look exactly like the filtered column except that
the pasted column will start one row up & there will be a blank on the last
row. is this possible within the tools available in excel or do I need to
write VBA code for it?