|
|
#1
11-15-2016, 10:25 AM
|
|||
|
|||
Automatically fill in names in a weekschedule
Hi Guys, I have an excel file with two sheets. 1 sheet called schedule, in this sheet I get the names of the workers and the shift they work and on which day this is. 1 sheet called weekschedule I have a schedule that I like to fill in by using a formula of an VBA code. Is there someone who can help me out. link to my file: https://drive.google.com/open?id=0B9...DNwZ2NxOF9FMWM Adile 
|
|
#2
11-15-2016, 04:27 PM
|
|||
|
|||
|
Hi Adile,
If you post your sheet here I would be happy to take a look.
|
|
#4
11-15-2016, 05:36 PM
|
|||
|
|||
|
I see 12 names for 11/14/2016 on the Schedule tab, but only 15 spots on the Weekshedule tab.
What do you want in what cell? A name, multiple names, what exactly? Last edited by jeffreybrown; 11-16-2016 at 05:31 AM.
|
|
#5
11-16-2016, 08:08 AM
|
|||
|
|||
|
I used the following array formula:
Code:
=INDEX(Schedule!$C$2:$J$85,MATCH(1,(Schedule!$J$2:$J$85=Weekschedule!$B13)*(Schedule!$C$2:$C$85=Weekschedule!G$3),0),4)
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Automatically Fill Cells in Other Worksheets
|
MatthewR | Excel | 4 | 07-09-2015 07:13 AM |
| Word Template: Fill out user E-Mail automatically | MS_Maverick | Office | 0 | 05-09-2014 12:50 AM |
| How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |
|
Automatically fill in bcc
|
prroots | Outlook | 1 | 06-29-2010 10:56 AM |
| Automatically entering/fill data in cells in Excel 2003 | dipdog | Excel | 0 | 08-17-2006 08:37 AM |
Windows 10 
Office 2013
Linear Mode
