Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-20-2019, 06:45 AM
Tesla Tesla is offline Windows 7 32bit Office 2003
Novice
 
Join Date: Sep 2018
Posts: 24
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, 7 views)
Reply With Quote
  #2  
Old 02-20-2019, 07:08 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,018
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Perhaps like the attached.
Attached Files
File Type: xlsx Distribute.xlsx (16.6 KB, 5 views)
Reply With Quote
  #3  
Old 02-20-2019, 11:26 PM
Tesla Tesla is offline Windows 7 32bit Office 2003
Novice
 
Join Date: Sep 2018
Posts: 24
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, 4 views)
Reply With Quote
  #4  
Old 02-21-2019, 12:07 AM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,367
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

Perhaps you should start by looking at your past posts on this topic. See, for example: http://www.msofficeforums.com/excel/...dividuals.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 02-21-2019, 01:34 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 433
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
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, 5 views)
Reply With Quote
  #6  
Old 02-28-2019, 07:48 AM
bosco_yip bosco_yip is offline Windows 10 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
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
Large Word doc duplicating large sections when I print it. Kea Word 3 05-30-2015 02:28 PM
Searching another persons contacts Hendo313 Outlook 1 07-10-2009 09:03 AM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft