1. Select column A
2. DataAutofilter, choose non-blank cells from dropdown list
3. EditJump (I'm not sure what is the original English word, it's the
Ctrl+G shortcut, please re-post it if you Found it), Advanced (this is the
push button in the bottom left corner of the dialog, please re-post its name,
too), choose the Visible cells only option
4. Copy and paste

Regards,
Stefi


€žAllan€� ezt Ã*rta:

I have data on one worksheet that needs to be copied onto another. The new
worksheet must have this data however it must diregard the blank cells.
I cannot sort and then delete as each cell contains a formula that
references another worksheet.
a1 = abc
a2 = def
a3 = blank cell
a4 = fgh
a5 = ijk

Many Thanks
Allan
new worksheet should read as
a1 = abc
a2 = def
a3 = fgh
a4 = ijk
there is no longer a blank cell and the total rows has been reduced by the
number of blank cells the original worksheet contained.