Filtered Data-Linking

[mzle22]

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?

 

[Pete_UK]

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

 

[mzle22]

Thanks Pete. I will give it a try.
--
mzle22

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

 

[Pete_UK]

You're welcome.

Pete