Filtered Data-Linking
 

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

Filtered Data-Linking
 

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

Filtered Data-Linking
 

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


"Pete_UK" wrote:

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

Filtered Data-Linking
 

You're welcome.

Pete

On Jul 31, 2:28*am, mzle22 wrote:
Thanks Pete. I will give it a try.
--
mzle22