| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you Filter using names from a generated list???
I have a macro that takes a list of peoples names from my data sheet, then
pastes them to a separate sheet and only leaves those names that appear 3 times or more. I would then like to use this list of names and go back to the original data sheet and filter by each name one by one. For example, if John Smith's name remains on my generated list, is there a way to plug his name in to the filter for the original data set?? The list of names generated is in column A of a sheet named "Employee Names" and the original data appears on a sheet entitled "Data" with the names in column H. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you Filter using names from a generated list???
What is it you would want to do when filtering the names? -- The Code Cage Team Regards, The Code Cage Team http://www.thecodecage.com ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=29100 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you Filter using names from a generated list???
When the list is filtered by that individuals name I am going to copy all the
data for that person and paste it on a new worksheet. Then I am going to the next name and the next and doing the same for each. "The Code Cage Team" wrote: What is it you would want to do when filtering the names? -- The Code Cage Team Regards, The Code Cage Team http://www.thecodecage.com ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=29100 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you Filter using names from a generated list???
I have a workbook that does just that, join our forums and make a post regarding this and then pm me where i will attach the workbook in your post, you will then be able to modify it to suite your needs! -- The Code Cage Team Regards, The Code Cage Team http://www.thecodecage.com ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=29100 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return a list of names, from a large list of repeated names. | Excel Worksheet Functions | |||
| Filter a list of names! | Excel Discussion (Misc queries) | |||
| create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
| How do I create/filter a list of names without duplications | Excel Discussion (Misc queries) | |||
| filter 400 names from list 1 from list 2 with 4000 names | Excel Worksheet Functions | |||
Hybrid Mode
