Changes

[[File:Applytoall.png|center|thumb|1500x1500px|APPLYTOALL]]  

[[File:Applytoall.png|center|thumb|1500x1500px|APPLYTOALL]]  

APPLYTOMANY is similar but you have to select a completed activity AND other stakeholder group(s). Other stakeholder groups can be entered manually in the formula, or you can click over to the Stakeholders sheet and select multiple group names while holding Ctrl on your keyboard. Alternatively, after selecting a completed activity, you can manually type stakeholder groups directly into the formula (each group must be separated by a comma). The output will be a duplication of the selected activity for as many stakeholder groups as you want. As with APPLYTOALL, this output will then need to be copy-pasted (as values!) into the table. Unfortunately this has to be done in 2 steps using copy-paste due to the constraints associated with Tables in Excel.   

APPLYTOMANY is similar but you have to select a completed activity AND other stakeholder group(s). Other stakeholder groups can be entered manually in the formula (separate each group with a comma), or you can click over to the Stakeholders sheet and select multiple group names while holding Ctrl on your keyboard. The output will be a duplication of the selected activity for as many stakeholder groups as you want. As with APPLYTOALL, this output will then need to be copy-pasted (as values!) into the table. Unfortunately this has to be done in 2 steps using copy-paste due to the constraints associated with Tables in Excel.   

[[File:Image11111111111111111111111.png|center|thumb|1500x1500px|APPLYTOMANY]]   

[[File:Image11111111111111111111111.png|center|thumb|1500x1500px|APPLYTOMANY]]