How can I copy information from one column, but not balnk cells?

T

thaenn

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?
 
R

Ron de Bruin

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
 
Top