Morning all,
I am fairly new to the macro/VBA world and need some help driving this project home. I am working on an employee attendance log that tracks hours used and hours remaining based off a static 40 hours. I have been able to record a macro that does what I need but its not very user friendly. I have also been able to find ways to code a few of the steps below but I can not seem to make them work together.
I have attached a sample of the recorded macro I am currently using. It has sufficed to this point but I am looking to refine the process. I understand that there are ways to do this manually, which I was doing previously, but this format is now being spread out company wide and I have been assigned to refine it. I need to keep it as "simple-stupid" as possible for the user.
What I am looking to do:
1- Copy information from Sheet 1 to Sheet 2.
2- Sheet 2 will then sort information by name alphabetically
3- Sheet 2 will include totals at each change in name
4- Sheet 2 will automatically update with each new entry on Sheet 1
5- Lock coding so unauthorized changes can not be made without stopping the macro/code from working
Any help would be greatly appreciated.
Thanks in advance.
- E
Bookmarks