Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula to populate while skipping blank fields
I would use a function which will take data from a worksheet which contains
some rows with blank fields, and populate a worksheet with the data in a continuous list (without including the blank rows). I am relatively new at Excel, so I need a simple explanation (i.e. I don't know how to write macros). Any help would be greatly appreciated. |
#2
|
|||
|
|||
Play with SpecialCells.
This code will select all rows with constant values in column A Dim rng As Range Set rng = Range("A1:A100").SpecialCells(xlCellTypeConstants) rng.EntireRow.Select -- HTH RP (remove nothere from the email address if mailing direct) "Chris Hudd" <Chris wrote in message ... I would use a function which will take data from a worksheet which contains some rows with blank fields, and populate a worksheet with the data in a continuous list (without including the blank rows). I am relatively new at Excel, so I need a simple explanation (i.e. I don't know how to write macros). Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
How do identify a blank cell in a formula | Excel Discussion (Misc queries) | |||
how do i create a blank cell in excel using a formula | Excel Worksheet Functions |