SAMCRO2014
Board Regular
- Joined
- Sep 3, 2015
- Messages
- 160
Hi there. I am attempting to create a loop using SUMPRODUCT to find a date within a date range for an employee number and returning a value. This is my situation.
I have an overtime workbook that list the dates (Column B) and hours of overtime worked (Column E) by employee number (Column A). I need to have the macro look up the hourly rate (Column V) in a separate workbook (Atlantic). The way the information is exported for 'Atlantic' is each employee number (Column H) has a start date (Column I) and end date (Column J) for a specific hourly wage (Column V).
For example:
Employee # 999999 worked overtime on:
- April 4, 2018 for 10.50 hours
- April 28, 2018 for 5 hours
- October 25, 2018 for 4 hours
Employee # 999999 hourly rates were:
- April 1, 2018 - August 23, 2018 $15
- August 24, 2018 - October 19, 2018 $18
- October 20, 2018 - March 31, 2019 $20
Required:
- Bring back the hourly rate for each day worked of overtime.
I have myself so confused on how to even start this even after watching YouTube videos.
Any advice?
I have an overtime workbook that list the dates (Column B) and hours of overtime worked (Column E) by employee number (Column A). I need to have the macro look up the hourly rate (Column V) in a separate workbook (Atlantic). The way the information is exported for 'Atlantic' is each employee number (Column H) has a start date (Column I) and end date (Column J) for a specific hourly wage (Column V).
For example:
Employee # 999999 worked overtime on:
- April 4, 2018 for 10.50 hours
- April 28, 2018 for 5 hours
- October 25, 2018 for 4 hours
Employee # 999999 hourly rates were:
- April 1, 2018 - August 23, 2018 $15
- August 24, 2018 - October 19, 2018 $18
- October 20, 2018 - March 31, 2019 $20
Required:
- Bring back the hourly rate for each day worked of overtime.
I have myself so confused on how to even start this even after watching YouTube videos.
Any advice?