| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple names
I have a excel sheet full of my customers names and my staff names. would
like to sort out under each customer's company, shows who are the staffs are attached to the customer in a main worksheet. Tried using LOOKUP but it only show 1 staff name but i have more than 1 staff attached to my customer. tried alot of methods but just can't do it. pls help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple names
datafilterautofilter
-- Don Guillett Microsoft MVP Excel SalesAid Software "freezerpang" wrote in message ... I have a excel sheet full of my customers names and my staff names. would like to sort out under each customer's company, shows who are the staffs are attached to the customer in a main worksheet. Tried using LOOKUP but it only show 1 staff name but i have more than 1 staff attached to my customer. tried alot of methods but just can't do it. pls help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple names
im using excel 2007... is it the same way?
"Don Guillett" wrote: datafilterautofilter -- Don Guillett Microsoft MVP Excel SalesAid Software "freezerpang" wrote in message ... I have a excel sheet full of my customers names and my staff names. would like to sort out under each customer's company, shows who are the staffs are attached to the customer in a main worksheet. Tried using LOOKUP but it only show 1 staff name but i have more than 1 staff attached to my customer. tried alot of methods but just can't do it. pls help. . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple names
im using excel 2007... is it the same way?
"Don Guillett" wrote: datafilterautofilter -- Don Guillett Microsoft MVP Excel SalesAid Software "freezerpang" wrote in message ... I have a excel sheet full of my customers names and my staff names. would like to sort out under each customer's company, shows who are the staffs are attached to the customer in a main worksheet. Tried using LOOKUP but it only show 1 staff name but i have more than 1 staff attached to my customer. tried alot of methods but just can't do it. pls help. . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple names
1. Press Ctrl+Shift+L while in the data.
2. Open the filter at the top of the Company column and pick one. 3. Select the results and copy 4. Move to the another sheet and choose paste. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "freezerpang" wrote: im using excel 2007... is it the same way? "Don Guillett" wrote: datafilterautofilter -- Don Guillett Microsoft MVP Excel SalesAid Software "freezerpang" wrote in message ... I have a excel sheet full of my customers names and my staff names. would like to sort out under each customer's company, shows who are the staffs are attached to the customer in a main worksheet. Tried using LOOKUP but it only show 1 staff name but i have more than 1 staff attached to my customer. tried alot of methods but just can't do it. pls help. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using cell names across multiple worksheets | Excel Discussion (Misc queries) | |||
| Deleting Multiple Names | Excel Discussion (Misc queries) | |||
| How to load multiple names ? | Excel Discussion (Misc queries) | |||
| how to reconcile multiple names for same customer | Excel Discussion (Misc queries) | |||
| Can I change the names of multiple cells at once? | Excel Discussion (Misc queries) | |||
Linear Mode
