Vanguard96
New Member
- Joined
- Mar 10, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
We use an outsourced Payroll service and export the payroll to excel and import to our ERP system to post. This JE is over 400 lines. I want to be able to Merge Column A, Column D, Column E which represent our GL account number, branch, and subaccount. Then Sum Column B, C & F related to the GL account, Branch etc. Image inserted. Green=merged Yellow = Sum