Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-20-2019, 06:45 AM
Tesla Tesla is offline distribute a large list among few persons Windows 7 32bit distribute a large list among few persons Office 2003
Advanced Beginner
distribute a large list among few persons
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default distribute a large list among few persons

Hi, would you please advise me on how I could distribute a large list among few persons, see attached format of what I want to do
Attached Files
File Type: xlsx 1.xlsx (10.7 KB, 13 views)
Reply With Quote
  #2  
Old 02-20-2019, 07:08 AM
xor xor is offline distribute a large list among few persons Windows 10 distribute a large list among few persons Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Perhaps like the attached.
Attached Files
File Type: xlsx Distribute.xlsx (16.6 KB, 11 views)
Reply With Quote
  #3  
Old 02-20-2019, 11:26 PM
Tesla Tesla is offline distribute a large list among few persons Windows 7 32bit distribute a large list among few persons Office 2003
Advanced Beginner
distribute a large list among few persons
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default

Thank you Xor, but the help you provided is hard for me to understand. Someone gave me a very easy solution some time ago, unfortunately I forgot it. The solution was on a single sheet. In fact sometimes I have to distribute a large list of 500-1000 entries to 20-50 persons. I think it doesn't look quite well to create 20-50 sheets if I use your solution. I attach my attempt to solve the problem in a way the one which I have forgotten was. I not very correct of course. If someone could give me help I would appreciate.
Attached Files
File Type: xlsx 1.xlsx (13.4 KB, 10 views)
Reply With Quote
  #4  
Old 02-21-2019, 12:07 AM
macropod's Avatar
macropod macropod is offline distribute a large list among few persons Windows 7 64bit distribute a large list among few persons Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Perhaps you should start by looking at your past posts on this topic. See, for example: https://www.msofficeforums.com/excel...dividuals.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 02-21-2019, 01:34 AM
ArviLaanemets ArviLaanemets is offline distribute a large list among few persons Windows 8 distribute a large list among few persons Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

In attachment is a possible solution.

To avoid problems with Excel ODBC query from table in same workbook, I made an Open event, which corrects query parameters whenever the workbook name or folder is changed. Because this, the workbook is in Macro Enabled format (*.xlsm). Be sure macros are allowed when you open the workbook.

As the workbook is macro-enabled, I posted it as zip-file (to be sure it is accepted).
Attached Files
File Type: zip ReportSelection.zip (22.5 KB, 12 views)
Reply With Quote
  #6  
Old 02-28-2019, 07:48 AM
bosco_yip bosco_yip is offline distribute a large list among few persons Windows 10 distribute a large list among few persons Office 2016
Novice
 
Join Date: Feb 2019
Location: Singapore
Posts: 7
bosco_yip is on a distinguished road
Default

Perhaps,

In "distribution" sheet C2, copied down :

=IF(A2="","",LOOKUP(ROWS($1:1),responsible!$B$2:$C $5))

Regards
Bosco
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to distribute a list of 400 among 27 individuals Tesla Excel 5 02-21-2019 02:22 AM
distribute a large list among few persons Large Groups (Distribution List) MaineLady Outlook 2 09-13-2016 08:17 AM
Formating Partial cells in a large list Zajac Excel 3 08-16-2016 09:13 AM
distribute a large list among few persons Large Word doc duplicating large sections when I print it. Kea Word 3 05-30-2015 02:28 PM
distribute a large list among few persons Searching another persons contacts Hendo313 Outlook 1 07-10-2009 09:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:13 PM.


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