darmok_jalad
New Member
- Joined
- Feb 22, 2022
- Messages
- 4
- Office Version
- 365
- 2019
- 2010
- Platform
- Windows
I'm hitting my head against the wall on this one....
So I have an issue where I'm tracking over time, the date it occurs, and a rolling count of how many hours each employee has. Easy and done. The part I'm struggling with is writing a code that would allow me (or someone else who isn't as savvy with Excel) to put in the current days' overtime information, and automatically copy anything with today's date on it onto a second worksheet, think as a log of who did overtime specific to that day.
So in this example, let's say I were to change Joe to 2/23/22 with 8 hours (my actual sheet adds it and drops the latest date to the bottom) is there a way to create a code that will pull anything that has today's date (lets say 2/23/22 is today) and copy the entire row automatically, and paste it into a separate table in a new worksheet to keep a rolling log of daily activities?
So I have an issue where I'm tracking over time, the date it occurs, and a rolling count of how many hours each employee has. Easy and done. The part I'm struggling with is writing a code that would allow me (or someone else who isn't as savvy with Excel) to put in the current days' overtime information, and automatically copy anything with today's date on it onto a second worksheet, think as a log of who did overtime specific to that day.
Name | Employee # | Total OT Hours | Date of OT | OT Hours Credited |
Joe | 12345 | 48 | 2/21/22 | 0 |
Bill | 56789 | 52 | 2/22/22 | 4 |
So in this example, let's say I were to change Joe to 2/23/22 with 8 hours (my actual sheet adds it and drops the latest date to the bottom) is there a way to create a code that will pull anything that has today's date (lets say 2/23/22 is today) and copy the entire row automatically, and paste it into a separate table in a new worksheet to keep a rolling log of daily activities?