Microsoft Office Forums Return List Based On Specific Value

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-12-2016, 01:15 AM
Helmszee Helmszee is offline Return List Based On Specific Value Windows 7 64bit Return List Based On Specific Value Office 2010 64bit
Novice
Return List Based On Specific Value
 
Join Date: Apr 2016
Posts: 1
Helmszee is on a distinguished road
Default Return List Based On Specific Value

Hi all, thanks for your help in advanced.



I run a basketball competition and am trying to use a mail merge to help generate the team sheets automatically.

I have an excel sheet which has every player in the competition and the team they play in. I have used a mail merge already to fill in the team name each week based on who they are playing, but what I now want to do is automatically populate the sheet with each of the players names who play in that team.

Is there a way to write to find 10 players names, who all play in the same team, for example 'Team A' and then put them in a column, 1 name per row:

Team A:
Joe Blogs
Super Man
Bat Man

and so on.

I'm hoping that makes enough sense that someone might be able to help.

Cheers
Helmszee
Reply With Quote
  #2  
Old 04-12-2016, 02:30 AM
macropod's Avatar
macropod macropod is offline Return List Based On Specific Value Windows 7 64bit Return List Based On Specific Value Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Provided your data are suitably arranged, that's quite possible.

If you could attach a copy of your workbook to a post showing the data structure with some representative data (delete anything sensitive), we'd gladly take a look at it to see what can be done. You can attach files via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return Value from Drop-Down List bartleby Excel 0 01-20-2016 07:45 PM
Return List Based On Specific Value Excel Validation Feature to Return Items from a List summerabc Excel 1 01-16-2015 04:37 AM
Return List Based On Specific Value Search for multiple texts in cell, return specific text mariur89 Excel 4 12-14-2014 01:33 AM
Page Break based on specific work mbesspiata Word 6 01-22-2014 12:40 PM
Force Kiosk published PPT to return to a specific slide after x amount of minutes jasoomian PowerPoint 1 07-31-2010 03:09 AM


All times are GMT -7. The time now is 03:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft