Matching and transferring data for 2 workbooks

[martinekone]

I currently have 2 excel files: 1 master and 1 file to be imported (Jan17 as attached)

With reference to my files, how do I copy the subtotal salary and expenditure for persons A and B from the Jan17 file to the correct column (ie. the next empty column) in the master file?

Is there a way to make it automated such that i can import the file to the master every month and the data gets inserted into a new column automatically?

 

[vletm]

martinekone
Is there normally more than two persons?

 

[Hui]

Martin

It is generally considered bad practice to cross post to different sites without notifying us

Please read the site rules: http://forum.chandoo.org/link-forums/new-users-please-read.17/