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: 8
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: 983
xor is just really nicexor is just really nicexor is just really nicexor is just really nicexor is just really nice
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: 8
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,098
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: 405
ArviLaanemets 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, 4 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: 5
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 04:15 PM.


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