Extracting data from separate worksheets into new worksheet

[Espilano]

I have no knowledge about VBA and hope you can help me here.

Background:
I have an expense report and employee data in the workbook as attached. I would like to extract data in expense report in column E (just the name) and total amount to the "working" sheet. I want to combine the duplicate names and show only the total amount to be paid to the respective employees. Then based on the name, I want to extract the employee ID, department and bank from "data" sheet to the "working" sheet.

Thank you!

[Marc L]

Attach an expected result workbook …

[Espilano]

No attachment....

[Marc L]

No result attachment, no help …

[sintek]

Here's one way...

Please Login or Register  to view this content.

[sintek]

Thanx for rep... pls mark thread as solved if you are satisfied with solution offered...