| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filtered Data-Linking
You're welcome.
Pete On Jul 31, 2:28*am, mzle22 wrote: Thanks Pete. I will give it a try. -- mzle22 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
| Sum of filtered data | Excel Worksheet Functions | |||
| Linking to a filtered (hidden) cells | Excel Discussion (Misc queries) | |||
| Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
| Using ONLY the data filtered | Excel Discussion (Misc queries) | |||
Hybrid Mode
