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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
How to copy info into blank cells within a column (going up the co 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Formula Audit mode active in one column only; cannot kill. 2
Returning "blank" when first cell is blank 4
Problems copying Large Amounts of Data in Excel 2007 1
copying cell contents from one worksheet to another (re-sorted lis 2

Back
Top