Passage Posted August 21, 2017 Share Posted August 21, 2017 (edited) 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! Edited August 21, 2017 by Passage Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.