| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I copy information from one column, but not balnk cells?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I copy information from one column, but not balnk cells?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cells to neighbor column after leaving the cell | Excel Worksheet Functions | |||
| How do I copy information and skip hidden cells? | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How to copy the hyperlink of a list of cells in another column | Excel Worksheet Functions | |||
| Rounding formula won't copy to other cells in column - why? | Excel Discussion (Misc queries) | |||
Hybrid Mode
