ShiftyThor
New Member
- Joined
- Mar 4, 2013
- Messages
- 14
Good day all, I am working on a sheet for a school, and would like to create an automatic selection from one sheet to another. The idea is to have one sheet with various details, and then another with a form for a gate pass. What I am aiming for is the name to appear on the gate pass, if the child has a "Yes" in a certain column.
<tbody>
</tbody>This is the master file which would hold various other information, date in date out etc. However I would require the above to then select "Yes" from the gate pass column to then extract the name and place it in the forms below to be printed:
<tbody>
</tbody>
There will be about 4 or 6 slips printed on one paper. The problem is when using the "if" command, it will not align the rows, other than doing a serious of if commands incorporating the previous slip. There are around 300 students. The idea is to save paper, and if a column is blank in the master file, it will not be selected in the gate pass sheet, but rather select the next available "Yes"
Many thanks
Name | Gate Pass Required | Person Collecting |
Tinashe Matambo | Yes | Mr. Matambo |
Verain Mungate | ||
Prince Mbazvo | Yes | Mrs. Maraidza |
<tbody>
</tbody>
Tinokura Gate Pass | Tinokura Gate Pass |
This serves to confirm that: | This serves to confirm that: |
"Name of Child to be picked" | "name of child to be picked" |
Has been given permission | Has been given permission |
to leave after his sporting | to leave after his sporting |
on 2 November 2019 | on 2 November 2019 |
Signed:________________ | Signed:________________ |
Tinokura Housemaster | Tinokura Housemaster |
Tinokura Gate Pass | Tinokura Gate Pass |
This serves to confirm that: | This serves to confirm that: |
"Name of Child to be picked" | "Name of Child to be picked" |
Has been given permission | Has been given permission |
to leave after his sporting | to leave after his sporting |
on 2 November 2019 | on 2 November 2019 |
Signed:________________ | Signed:________________ |
Tinokura Housemaster | Tinokura Housemaster |
<tbody>
</tbody>
There will be about 4 or 6 slips printed on one paper. The problem is when using the "if" command, it will not align the rows, other than doing a serious of if commands incorporating the previous slip. There are around 300 students. The idea is to save paper, and if a column is blank in the master file, it will not be selected in the gate pass sheet, but rather select the next available "Yes"
Many thanks