Hi. Is there a way to list, on a separate sheet in the same workbook, only
rows of data with a value in a specific column? I want to list closed leads
and all data in that row) as long as there is a specific value of 100 or 0
in column F. If there is a different value in column F for that lead, then I
don't want it to
appear on this list.
Is there a way to do this with a formula and not a pivot table and
automatically instead of filtering? Ideally, I would like it to add the row
to the bottom of the list.
For example, my colums are (A-I):-
Opportunity ID, Reminder Call, Customer Name, Opportunity, Sales Stage,
Probability, First Name, Last Name and Received Date
Thanks