How to extract a few results (names) from i big list into a small
 

I want help to make this possible: 60 salesmen have their own sheet with
different results in different columns, one row for each day of the year.
Lets say 10 of them make a sale and/or an appointment per day, but different
people from day to day. Is it possible for me to make a day by day list where
only those with sales appear? Of course I can make a helpfile for a day by
day list with all 60, sort it and make and extraction with those 10 at top
with sales, but if it is an another and easier way I'd like to know.

Jan Ingvoldstad

How to extract a few results (names) from i big list into a small
 

Jan
Since, as you said, doing what you want manually over 60 sheets would be
a nuisance at best, I would suggest VBA.
You would have a sheet for Sales (and sheets for other things as well) and
the VBA code would simply loop through all the salesmen's sheets, and filter
the rows in each sheet for Sales, and copy all Sales entries and put them
all in the Sales sheet, then sort that sheet as you wish.
If this sounds like it might work for you, send me your file or a sample
of your file and I'll work up some code for you. You can fake the data as
you wish, I want just the layout. Include a Sales sheet and layout of how
you want all the Sales data placed. Also tell me what version of Excel you
are using. My email address is . Remove the "nop"
from this address. HTH Otto
"Jan" wrote in message
...
I want help to make this possible: 60 salesmen have their own sheet with
different results in different columns, one row for each day of the year.
Lets say 10 of them make a sale and/or an appointment per day, but
different
people from day to day. Is it possible for me to make a day by day list
where
only those with sales appear? Of course I can make a helpfile for a day by
day list with all 60, sort it and make and extraction with those 10 at top
with sales, but if it is an another and easier way I'd like to know.

Jan Ingvoldstad