Forum Discussion
dates
Steve-
Please review the attached worksheet I have added some formulas and notes to the FlowSheet and LeadSch. Unfortunately, the way you have set up LeadSch is prevents an Index Match formula from working. However, I have added a few different formulas that should help get you accomplish your task.
If you don't want some of the values like 1,2,3,4,5 to show in the worksheet you can format them as white font. This way the user doesn't see them....
Mike, here's the large workbook I'm using LighthouseLdrSchTemp which has several worksheets, two of which are under consideration. LeadSch shows the church leadership schedules for all Sabbaths in June. FlowSheet shows the jobs and assignments for a particular service mostly drawn from LeadSch but some will be just typed in. By changing the date in k3 I want to fill in the necessary names, but I'm such a novice at this that I'm struggling to understand what you have been telling me previously. Hope you are not getting sick of this.
Steve-
Please review the attached worksheet I have added some formulas and notes to the FlowSheet and LeadSch. Unfortunately, the way you have set up LeadSch is prevents an Index Match formula from working. However, I have added a few different formulas that should help get you accomplish your task.
If you don't want some of the values like 1,2,3,4,5 to show in the worksheet you can format them as white font. This way the user doesn't see them....