Forum Discussion

Copper Contributor

May 18, 2020

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 ...

Attendance - Prototype.xlsx135 KB

BI & Data Analysis

excel

Formulas and Functions

Macros and VBA

Riaan1055

Copper Contributor

May 18, 2020

Thanks Riny_van_Eekelen for the assistance.

Appreciate it very much.

Thanks

Kind Regards

Riaan

Riaan1055

Copper Contributor

May 22, 2020

Hi Riny_van_Eekelen

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.