Forum Discussion
Excel _Attendance register
Hi Guys
Hope you are doing well.
I need assistance regards to a attendance register i'm working on.
I have 4 different shifts - A, B, C, D with 4 supervisors and the employees that work according to the specific shifts.
What I've done so far - I inserted a drop-down list with the different shifts that pulls in the supervisor per shift.
What I need - I need excel to pull in the employees under the specific shifts automatically into the register.
I've attached the excel sheet.
Kind regards
Riaan
10 Replies
Riaan1055 Start by changing the shift names to Shift_A, Shift_B etc. so that they become the same as the named ranges you have given to the shift lists.
Empty the area where you now have the employees listed B5:D24 and insert enough empty rows to be able to contain your largest shift.
Provided you are on a fairly recent version of Excel, enter =INDIRECT(C3) in B5. It should pick-up the content of the entire named ranged based on the selected shift in C3.
Attached your file, including these changes for reference.
Hi Riny
I tried your instructions and I still seem to not get it. Will you please have a look at my changesRiny_van_Eekelen
Riaan1055 Have a look again at the attached file. In case it doesn't work for you, what Excel version are you working with?
