Hi thaenn

You can use AutoFilter if the cells are blank and fileter on non blanks.
Then copy to another sheet

You can also use EasyFilter that have a option to do this and also
if the cells in the column contains a formulas that display ""
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"thaenn" wrote in message ...
I have created a new column that only has information in certain cells
(depending on the input information).

I will like to "copy" that information on to another worksheet, leaving out
all of the blank cells in that particular column (in other words, condensing
the original extended column to a smaller list that contains infomation only)?

Any suggestions?