Merging Data to import a shorten JE version to the ERP system

V

Vanguard96

New Member
Joined
Mar 10, 2023
Messages
1
Office Version
  1. 365
Platform
  1. 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
 

Attachments

  • Screenshot 2023-03-10 145406.jpg
    Screenshot 2023-03-10 145406.jpg
    145.2 KB · Views: 3

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You must log in or register to reply here.

Similar threads

A
  • Question
Need VBA code to copy/paste data from one sheet to another with multiple criteria and complex structure
Replies
0
Views
1K
Amir Wisal
A
N
  • Question
Join data from second worksheet with delimited list values (mults) to another worksheet with one value per cell/row and keep 1:1 relationship
Replies
2
Views
1K
HeadAgainstABrickWall
H
L
  • Question
VBA Issue / Exporting Excel File to CSV Causing Double Quote Issues
Replies
0
Views
3K
Laurence Harper
L
T
  • Question
İmport Text File With Excel Vba
Replies
1
Views
2K
tevfikuzunn
T
S
  • Question
Help with imported data from ERP system - issues with leading zeros, text to date
Replies
1
Views
1K
schbrownie
S

Forum statistics

Threads
1,214,911
Messages
6,122,194
Members
449,072
Latest member
DW Draft

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top