| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I consolidate some cells in a column in Excel?
I am trying to copy data in a column from one worksheet to another in the
same workbook, However I only want the data that meets a certain criteria. I would like the data that I retrieve to be consolidated instead of showing empty cells in bewtween. How do I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I consolidate some cells in a column in Excel?
Hi Petester,
1. "Autofilter" option in "DATA-Filter" menu will filter data based on the specified conditions (including non-zero), 2. Select the filtered data, goto the required sheet and right-click on the required cell and use "Paste Special" option and select values then press "OK". With kind regards, NAVEEN "Petester" wrote: I am trying to copy data in a column from one worksheet to another in the same workbook, However I only want the data that meets a certain criteria. I would like the data that I retrieve to be consolidated instead of showing empty cells in bewtween. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Multiply two columns in Excel or one column by one number | New Users to Excel | |||
| Sort Excel Column on Fifth Character | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
Hybrid Mode
