Forum Discussion
Excel _Attendance register
Hope You're doing we Will it be possible for you to assist me again with an attendance register I'm working on please. As I have 4 different shifts, I'm getting the data of shift a when the drop down changes to shift b, c, d the data aren't pulling through.
You'll find the back end data on the lists sheet and the Register on TA van Wyk sheet. The drop down is in B1.
Riaan1055 Am not sure that this makes any sense. How do you intend to update what you call the "back end registers"? Why then not create one separate sheet for every shift?
If I would want to design a more dynamic approach, I would start by creating a set of tables that tie Employees, Machines and Shift calendar together. Then the Attendance sheet would set the Shift and Time period for which you want the overview, and then all other information should get pulled in automatically from the other tables. Haven't really thought through it and it will certainly be more work that just helping with some Excel formulae.
I thought if I build a back end Attendance register exactly the same as the actual attendance that it will be possible to pull through all the info to the actual attendance register, that's why all the extra tables have been created.
I basically want it to have a drop-down in the first row: Attendance_Register_Shift_A, B, C, D and when it changes the employee info pulls through with the machine info included.
I tried to work on your previous info but only seem to get Shift A's info and not the the rest.
What do you suggest? Riny_van_Eekelen
First of all, you merged cells B1 and C1. So, I couldn't select any option to begin with.
And then you added a lot of extra tables in "Lists". And you added formulae with the @sign. Why?
What seemed to be a simple question to begin with has now become rather unclear. What is it exactly that you are trying to achieve?
