Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying non-blank rows only
How could I set set up a table such that, if I copied the whole table to a
new sheet only the rows containing data would be copied, and the remaining rows would be blank. Example: If rows 1 and rows 3 contained cells with data and rows 2 and 4 were empty, how could I set up a filter (or formula/VB macro etc) such that any data manually entered into a row would display but if the filter for that row were set to a "N", for example, the row would not display data? Many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying non-blank rows only
Try using the =ISBLANK() function and then sort the data by true/false
The isblank will tell you if a cell is blank. This would assume that the valid rows of data have a value in at least one column. If you can't depend of there always being a value in a specific column then you the and(isblank(a1), isblankk(b1), ...) funtion to test multiple values. Good Luck -- Stewart Rogers DataSort Software, L.C. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying non-blank rows only
Stewart,
Many thanks for your help - very useful - didn't know there was such a function! Best wishes Tony "Datasort" wrote: Try using the =ISBLANK() function and then sort the data by true/false The isblank will tell you if a cell is blank. This would assume that the valid rows of data have a value in at least one column. If you can't depend of there always being a value in a specific column then you the and(isblank(a1), isblankk(b1), ...) funtion to test multiple values. Good Luck -- Stewart Rogers DataSort Software, L.C. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
Delete blank row only if 2 consecutive blank rows | Excel Programming | |||
Copying and pasting a worksheet to a blank and removing blank rows | Excel Programming | |||
Copying non-blank rows to another sheet... | Excel Programming |