Sorting a range from on sheet to another
Sorting a range from on sheet to another
(OP)
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.
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.





RE: Sorting a range from on sheet to another
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.
RE: Sorting a range from on sheet to another
=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.
RE: Sorting a range from on sheet to another