Sample attached
Certainly, I did not think of doing that, new to the help forum!
The attached screen shots are the two worksheets in the spreadsheet I am creating.
In 'frontend' you will see a drop down list and when a school site is selected I need it to pull data from the other worksheet 'Master' and populate the cells marked with the red arrows under the staff position title for that school.
Thanks again for any suggestions or ideas!
|