I have a database with EE's hours, if the pay period crosses months the system separates the time into 2 rows. I have several columns of different time that I need it to sum for each employee and paste it into one row with the totals.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
VBA sum and combine rows
0
Discussion
Hmm. What's your question?
Variatus (rep: 4889) Jan 9, '20 at 8:45 pm
I need it to sum for each employee and paste it into one row with the totals. and remove the duplicate rows.
excel
excel
PelatronHR Jan 9, '20 at 10:08 pm
Answers
0
There is an XL item which removes duplicates so you could try that
Then you could sort the results by employee
Then you could sum the cols as required
Alternatively you could post a sample workbook and a bit more detail as to how to identify the duplicates, which columns have which times and what units they are in and if you want the sum to be in the same units. Do you want the totals by month or from day one.