Help with excel spreadsheet - formulas/macros/VBA
Budget: $10 – $30 AUD
See attached spreadsheet
Be able to select from the drop down box ( from one area at a time only) across all three of the following tabs ( including the Title, Access and Total Hours):-
i. Mandatory Education
ii. Role Requisite
iii. Cont Prof Learning
To populate into the REF Template tab – is it possible to have it populate under the different titles creating a new row each time.
I.e REF TEMPLATE TAB: - Staff Mandatory Education Once only F2F
SCHHS Orientation
F2F / LOL
2.50
SCHHS Staff Local Induction
F2F
8.00
Aboriginal & Torres Strait Islander Cultural Practice Program
F2F / LOL
6.00
In this example it would only have been for area 3C
TRAINING
ACCESS
TOTAL HRS
3A
3B - COVID WARD
3C
ALL STAFF MANDATORY EDUCATION
TOTAL HRS
ACCESS
25.55
Complete Training Once Only
SCHHS Orientation
F2F / LOL
2.50
Yes
Yes
SCHHS Staff Local Induction
F2F
8.00
Yes
Aboriginal & Torres Strait Islander Cultural Practice Program
F2F / LOL
6.00
Yes
Cultural Diversity
LOL
0.25
Person Centred Care
LOL
0.25
No
Prevention & Management of Musculoskeletal Disorders
LOL
0.30
There will be data under other areas in these tabs as this eventuates however only want to be able to populate the information from one column at a time into the REF template.
Be able to select from the drop down box ( from one area at a time only) across all three of the following tabs ( including the Title, Access and Total Hours):-
i. Mandatory Education
ii. Role Requisite
iii. Cont Prof Learning
To populate into the REF Template tab – is it possible to have it populate under the different titles creating a new row each time.
I.e REF TEMPLATE TAB: - Staff Mandatory Education Once only F2F
SCHHS Orientation
F2F / LOL
2.50
SCHHS Staff Local Induction
F2F
8.00
Aboriginal & Torres Strait Islander Cultural Practice Program
F2F / LOL
6.00
In this example it would only have been for area 3C
TRAINING
ACCESS
TOTAL HRS
3A
3B - COVID WARD
3C
ALL STAFF MANDATORY EDUCATION
TOTAL HRS
ACCESS
25.55
Complete Training Once Only
SCHHS Orientation
F2F / LOL
2.50
Yes
Yes
SCHHS Staff Local Induction
F2F
8.00
Yes
Aboriginal & Torres Strait Islander Cultural Practice Program
F2F / LOL
6.00
Yes
Cultural Diversity
LOL
0.25
Person Centred Care
LOL
0.25
No
Prevention & Management of Musculoskeletal Disorders
LOL
0.30
There will be data under other areas in these tabs as this eventuates however only want to be able to populate the information from one column at a time into the REF template.