I know this is a really odd place to post this but I don't have any idea who else to ask! Hopefully you guys can help or direct me somewhere that can help.
I have to gather information for payroll purposes at my current job. We use Excel to compile the information and since we've recently expanded and added over 100 additional employees, I've found the way that I'm currently doing it is extremely time consuming and can be done by a macro. At first, employees are displayed like the image below. I need a macro that removes the employees name and the employees compiled weekly hours (the hours underlined in yellow on the image) and places them in a new Excel sheet (the looks similar to the second image).
Ultimately, I would love if someone could explain and teach me how to write and install this macro. Please and thank you!
View attachment 1100
View attachment 1101
I have to gather information for payroll purposes at my current job. We use Excel to compile the information and since we've recently expanded and added over 100 additional employees, I've found the way that I'm currently doing it is extremely time consuming and can be done by a macro. At first, employees are displayed like the image below. I need a macro that removes the employees name and the employees compiled weekly hours (the hours underlined in yellow on the image) and places them in a new Excel sheet (the looks similar to the second image).
Ultimately, I would love if someone could explain and teach me how to write and install this macro. Please and thank you!
View attachment 1100
View attachment 1101
Last edited by a moderator: