Harwookf,

Take a look at Data - Filter - Advanced filter. It will do exactly as you have asked. You
have to set up a criteria range somewhere on the sheet. Or you can use Autofilter, then
copy/paste the stuff.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"harwookf" wrote in message
...
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