Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup to create List
Thanks in Advance:
my data looks like this in columns B to Q heading1 heading2 heading3 heading4 heading5 heading6 Sales Rep. name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 MNP name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 YRS blank row name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 YRS blank row name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 MNP name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 MNP etc. etc. On the same sheet,(tab) I need to create a list or organize to print only for one 'Sales Rep.' I have drop down list in cell AD3 to select one of the three 'Sales Rep.' What I need is to have a list (data) copied from the above list, and create a new list in AA10 and below. for example if ABC is selected in my dropdown list at AD3 then the list should look like this. heading1 heading2 heading3 heading4 heading5 heading6 Sales Rep. name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup to create List
Hi,
Once you select a name from the drop down list, highlight the results, press CTRL+G, special, visible cells only (is in your right side), then press CTRL + C, go to cell AA10, press CTRL + V "raz" wrote: Thanks in Advance: my data looks like this in columns B to Q heading1 heading2 heading3 heading4 heading5 heading6 Sales Rep. name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 MNP name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 YRS blank row name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 YRS blank row name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 MNP name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 MNP etc. etc. On the same sheet,(tab) I need to create a list or organize to print only for one 'Sales Rep.' I have drop down list in cell AD3 to select one of the three 'Sales Rep.' What I need is to have a list (data) copied from the above list, and create a new list in AA10 and below. for example if ABC is selected in my dropdown list at AD3 then the list should look like this. heading1 heading2 heading3 heading4 heading5 heading6 Sales Rep. name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup to create List
Thanks, I actually Need to do it with lookup.
"Eduardo" wrote: Hi, Once you select a name from the drop down list, highlight the results, press CTRL+G, special, visible cells only (is in your right side), then press CTRL + C, go to cell AA10, press CTRL + V |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup to create List
This sounds like a perfect layout for using Data|filter|Autofilter.
(I'd drop the empty rows, though.) Select your entire range (don't let excel guess!) and then apply the autofilter. You can use the dropdown arrows for the sales rep to show the rows/records associated with the person you choose. raz wrote: Thanks in Advance: my data looks like this in columns B to Q heading1 heading2 heading3 heading4 heading5 heading6 Sales Rep. name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 MNP name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 YRS blank row name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 YRS blank row name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 MNP name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 MNP etc. etc. On the same sheet,(tab) I need to create a list or organize to print only for one 'Sales Rep.' I have drop down list in cell AD3 to select one of the three 'Sales Rep.' What I need is to have a list (data) copied from the above list, and create a new list in AA10 and below. for example if ABC is selected in my dropdown list at AD3 then the list should look like this. heading1 heading2 heading3 heading4 heading5 heading6 Sales Rep. name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC name 1 Company 121 556 50 5463 ABC -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a multi column lookup list? | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
How to create adress list so can mail merge and create labels? | Excel Discussion (Misc queries) | |||
Want to Create a List in Excel 2002; Don't see List in Data Menu? | Excel Discussion (Misc queries) | |||
Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) |