Lookup codes and names and add costs

HMN93

New Member
Joined
May 31, 2014
Messages
20
Hi everyone,

I would appreciate it if someone can help me with this.
I have a workbook of 13 sheets. All 13 sheets contain the same information:Activity-Employee Code-Employee Name-Code1-Cost1-Code2-Cost2.
I'll show a small example to illustrate my case:
I have a table containing all Employees' Name and code
Employee NameEmployee Code
Mark900
Joe901
Sally902
Sam903
Jesse904
Ally905
D.O800
Liam801
Al802

<tbody>
</tbody>

This Table is in Sheet1 of the same workbook.

Now Sheet2 Contains the following:
ActivityEmployee CodeEmployee NameCode1Cost1Code2Codet2
AMark9001020$ 101020$ 15
A-105Joe9011010$ 201010$ 18
A-S05Al8021020$ 151010$ 20
B-106D.O8001040$ 181020$ 15
B-S06Jesse941020$ 201040$ 20

<tbody>
</tbody>

What I need to happen in this sheet is to extract all codes with the corresponding Employee Name and cost.
Let's Take for example Code 1020:
I need to have the following:
Employee NameCost1
Mark$ 10
Al$ 15
Jesse$ 20

<tbody>
</tbody>

Employee NameCost2
Mark$ 15
D.O$ 15

<tbody>
</tbody>

And then Having the Total Summary Table for both Cost (Cost1+Cost2)
Employee NameTotal Cost
Mark$ 25
Al$ 15
Jesse$ 20
D.O$ 15

<tbody>
</tbody>

By this the data for Sheet2 will be done.

Now if I jump to Sheet3 and do the same procedure, I'll end up with this total summary table :
Employee NameTotal Cost
Sally$ 35
Sam$ 10
Mark$ 17
Jesse$ 20

<tbody>
</tbody>


Now the final table that I need to reach is a table that sum all costs for same employee across multiple sheets for a specific Code.
The Final Table of the example shown above would be like this:
Code1020
Employee NameCost
Mark$ 42
Sally$ 35
Sam$ 10
Jesse$ 40
D.O$ 15
Al$ 20

<tbody>
</tbody>

I need to do this using formula and not filter. I would appreciate it someone can help with this!
 

HMN93

New Member
Joined
May 31, 2014
Messages
20
No i am not allowed to. I solved one part of this by using index but after that I didn't know how to proceed.
 

Forum statistics

Threads
1,082,344
Messages
5,364,806
Members
400,814
Latest member
gangstar67

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top