Multiple names

  • Thread starter Thread starter freezerpang
  • Start date Start date
F

freezerpang

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.
 
im using excel 2007... is it the same way?

Don Guillett said:
data>filter>autofilter>>>>>

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)


.
Click to expand...
 
im using excel 2007... is it the same way?

Don Guillett said:
data>filter>autofilter>>>>>

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)


.
Click to expand...
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help sorting records over multiple worksheets 10
HELP - A formula or sheet you want to move or copy contains the name .... 0
Help with conditionally unhiding columns 1
Pull info from multiple worksheets into one Master 2
Construct staff pay timesheet 1
Formula from various sheets 4
Countif & Ranges Question 6
Pivot Table for Dummies 1

Back
Top