You could apply autofilter to the data in sheet2 according to your
criteria (if necessary, use a helper column to set up your criteria
and filter on that), then highlight the visible cells and copy/paste
them into sheet1.

Hope this helps.

Pete

On Jul 31, 12:10*am, mzle22 wrote:
I am working with a form that was created in Excel. Currently the data is
manually entered into the form from a master Excel file. I only enter data
into the form that meets a certain criteria in the master file. Is there any
way I can pull data into a worksheet(1) from another worksheet(2) that only
pulls data with a certain criteria?
--
mzle22