Not quite automatic, but I'd try to apply data|filter|autofilter
Filter by the required criteria and then copy the visible cells to the other
sheet.



Brian wrote:

I'm trying to come up with a way have data from one tab populate on another
tab if it meets certain criteria.
On tab 1, I have about 40 rows of data in about 6 columns. I'd like to have
the data from tab 1 automatically populated on tab two if the information in
the rows meets certain criteria.
Any suggestions?

--

Dave Peterson