Hello all!
I'm fairly new to automation and haven't found a good way to add totals from one column based on the payroll number of another column.
Our financials department looks at each row of payroll data from a spreadsheet and clears each check out from our financials system. The hurdle I can't get over yet, is the fact that they look at the total number for each payroll and compare it in the financials system before clearing the check. Does anyone know how to loop through Excel and while the payroll is the same number (column H) add the tran amount (column D) to a variable for comparison in the financial system? See screen shot below.
Example: start with payroll 1405 and loop through until it reaches the next payroll number, while doing so, add the tran amounts together.
Thank you for your help in advance!
