| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range without Blank values
Are these values or formulas or a mixture?
If they are not a mixture, you can: select A1:A10 edit|goto|special|check constants (or formulas) Edit|copy then go to A1 of the second sheet edit|paste If you need a macro, you can record one when you do it manually. wrote: Hello: i would appreciate help with the following I have a range (A1:A10) on Sheet1, with names of people. Some of the cells in this range are blank. On Sheet2, I want to populate the column A (from A1 downward) with the list of names from Sheet1, range (A1:A10) but without any blank cells. Thus for example if on Sheet1, in range A1 to A10 if only cells, A3, A8 & A10 have names & other cells in range A1:A10 are blank, then on Sheet2, I would like cells A1, A2, A3 to have the values of A3, A8 & A10 from sheet1 TIA Vinay -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine and display values in range in 1 cell but skip blank cells | Excel Worksheet Functions | |||
| Need blank if no values in range getting value at the mo' | Excel Worksheet Functions | |||
| Count Non-Blank Values in a Table but only for a range | Excel Worksheet Functions | |||
| Sum of unique values within a range with blank cells | Excel Worksheet Functions | |||
| Creating a new worksheet by checking for blank values in a range | Excel Programming | |||
Threaded Mode
