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

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.

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.
>
>