Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find a group of names in a long list | Excel Discussion (Misc queries) | |||
want a list of selectable names on my worksheet | Excel Worksheet Functions | |||
Help to extract text when using LIST & AUTOFILTER | Excel Discussion (Misc queries) | |||
How- seperate a combined list by filtering out first list of names | Excel Worksheet Functions | |||
how do i set up a list of names on a sheet frm various sheets in e | Excel Discussion (Misc queries) |