How to create needed macro for timesheet

Joshua Worrell 0 Reputation points
2023-01-13T19:22:28.1266667+00:00

I need to write a macro to log entries for a respective pay period based on entries keyed by the user for that period. A user will key in hours worked into C19-34. They will then click the command button 1 "Post Hours". The script will take the total hours in C35 and enter the value next to the respective pay period in column G. Users will only be able to key entries in the green highlighted area. The sheet will be locked for everything else. No idea how to write this script.

Capture

Microsoft 365 and Office | Development | Other
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.