|Subject:||Extracting selected data|
|Posted by:||Sparky (450…@london.com)|
|Date:||Sat, 18 Oct 2003|
Win98SE / Excel 2000
I operate a spreadsheet that tracks sales for drivers for a courier company.
The workbook has multiple sheets that are all formatted in a similar way -
each week of the year has 40 rows, listed one after the other on each sheet.
The first sheet is a driver reference sheet listing driver names, driver
numbers, do they pay for radios, rate of compensation, etc. The other
sheets pull this information to compile lists of total sales, payroll
information, top performers, etc. It's the top performers sheet that is
causing me problems.
We post a list of the top six drivers for every week. On my top performers
sheet I rank each driver based on total sales, with a column for number and
name, total sales, brokerage and ranking.
Ideally what I would like to do is create a Word document that would extract
the top six drivers, in order, from my top performers sheet, putting the
required info into specific cells in a table. If this isn't possible I'd
settle for an additional worksheet that would have this information
automatically filled in, in order. I need to be able to specify which week
I'm interested in, extract just six lines of information (leaving the top
performers sheet unchanged) and have this info turn up somewhere else.
I'm not particularly gifted when it comes to spreadsheets so complex scripts
and pivot tables will probably be beyond me. Having said that, any help
would be appreciated.
Thanks in advance.