Re: Extracting selected data

Giganews Newsgroups
Subject: Re: Extracting selected data
Posted by:  Debra Dalgleish (d…
Date: Sat, 18 Oct 2003

In Microsoft Word, you can use the Mail Merge wizard to connect to your
Excel workbook. The data source can be filtered, so that only the date
you select will be in the merged document.

To filter the list in Word 2002, click the dropdown arrows in the
Recipients List headings, select Advanced, and select your criteria.

Sparky wrote:
> 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.

Debra Dalgleish
Excel FAQ, Tips & Book List



In response to

Extracting selected data posted by Sparky on Sat, 18 Oct 2003