Sorting a range from on sheet to another 2

[jelenko]

I have on 'Sheet 1' the following spreadsheet and will be adding information on a daily basis:

Last First Full name Greening
Stein Andrew Andrew Stein Chair
Mess Ted Ted Mess Interest
Peck Lois Lois Peck Member
Dean Will Will Dean Member
Lean Dick Dick Lean
Shep Ben Ben Shep Interest

Is it possible to display the same spreadsheet on 'Sheet 2' minus rows where "Greening" is blank? That is "Dick Lean" would not be shown, but all other rows will.

 

[Denial]

Assuming you are using Excel, you can achieve this without requiring a second sheet.

Use the "filter" capability (Data > Filter > Autofilter). You can then choose whether you want to see all rows, just "interest" rows, just rows where the entry is blank, or just rows where the entry is non-blank.

 

[zappedagain]

Another option is to set up your second spreadsheet with IF statements. Here is the formula for Sheet2 cell A2:

=IF(Sheet1!$D2="","",Sheet1!A2)

Here I assume your 'Greening' data is in Column D. This checks if column D is blank; if it is the cell gets blank data otherwise it gets a copy of the data from Sheet1. Copy this across the columns of interest and down as many rows as you like.

This is going to leave blank rows when 'Greening' is blank.

 

[jelenko]

Thank you for the input. It has certainly helped me.