hi
I have many sheets and each sheet have the same structure and every time I add a new names and data and add a new sheets , so what I want in sheet RESULT merge all of data and summing the values for specific columns COL B,E,F,K,L,M as you see in all of sheets sometimes repeat the names then should merge and summing the values and sometimes the name is existed in sheet but not are existed in other sheet so it should copy to the bottom in sheet result so it should all of data in all of the sheets merge and summing the values so if that's possible create the headers based on the sheets and bring the data as in sheet result
so if that's not clear or need attach the file just inform me
sheet1
sheet2
sheet3
sheet result
I have many sheets and each sheet have the same structure and every time I add a new names and data and add a new sheets , so what I want in sheet RESULT merge all of data and summing the values for specific columns COL B,E,F,K,L,M as you see in all of sheets sometimes repeat the names then should merge and summing the values and sometimes the name is existed in sheet but not are existed in other sheet so it should copy to the bottom in sheet result so it should all of data in all of the sheets merge and summing the values so if that's possible create the headers based on the sheets and bring the data as in sheet result
so if that's not clear or need attach the file just inform me
sheet1
1.xlsm | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | ITEM | NAME | NUMBERS OF HOURS | WAGES | CASE | 0.12 | 0.03 | 1.00 | 1.00 | 1% SUIT | UNITED TAXES | TAX1 | |||
2 | PAID | UNPAID | |||||||||||||
3 | 1 | ALI MOHAMEED | 11 | 12 | 1 | 1 | 1 | 1 | 6 | 4 | 45 | 1 | 1 | ||
4 | 2 | ABDULQASEM | 12 | 23 | 3 | 3 | 3 | 3 | 7 | 5 | 78 | 3 | 3 | ||
5 | 3 | ALSA ALDEEF | 5 | 5 | 24 | 10 | 81 | 37 | 9 | 0 | 34 | 87 | 78 | ||
6 | 4 | AHMED OMAR | 6 | 6 | 90 | 11 | 82 | 38 | 10 | 21 | 87 | 10 | 56 | ||
7 | 5 | MOHAMMED ALI | 7 | 7 | 87 | 12 | 83 | 39 | 11 | 13 | 98 | 57 | 45 | ||
8 | 6 | MAHMOUD | 8 | 8 | 45 | 13 | 84 | 40 | 12 | 34 | 14 | 46 | 34 | ||
1 |
sheet2
2.xlsm | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | ITEM | NAME | NUMBERS OF HOURS | WAGES | CASE | 0.12 | 0.03 | 1.00 | 1.00 | 1% SUIT | UNITED TAXES | TAX1 | |||
2 | PAID | UNPAID | |||||||||||||
3 | 1 | ALI MOHAMEED | 3 | 3 | 3 | 3 | 3 | 3 | 7 | 5 | 78 | 3 | 3 | ||
4 | 2 | ABDULQASEM | 45 | 76 | 24 | 10 | 81 | 37 | 9 | 0 | 34 | 87 | 78 | ||
5 | 3 | ALSA ALDEEF | 45 | 45 | 90 | 11 | 82 | 38 | 10 | 21 | 87 | 10 | 56 | ||
6 | 4 | AHMED OMAR | 45 | 34 | 87 | 12 | 83 | 39 | 11 | 13 | 98 | 57 | 45 | ||
7 | 5 | MOHAMMED ALI | 45 | 34 | 45 | 13 | 84 | 40 | 12 | 34 | 12 | 46 | 34 | ||
8 | 6 | KHALID ALI | 22 | 47 | 88 | 11 | 10 | 20 | 30 | 10 | 0 | 46 | 34 | ||
2 |
sheet3
3.xlsm | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | ITEM | NAME | NUMBERS OF HOURS | WAGES | CASE | 0.12 | 0.03 | 1.00 | 1.00 | 1% SUIT | UNITED TAXES | TAX1 | |||
2 | PAID | UNPAID | |||||||||||||
3 | 1 | ALI MOHAMEED | 34 | 67 | 68 | 89 | 90 | 67 | 54 | 67 | 78 | 34 | 67 | ||
4 | 2 | ABDULQASEM | 35 | 68 | 69 | 90 | 3 | 3 | 3 | 3 | 3 | 3 | 0 | ||
5 | 3 | MAHMOUD SALEM | 36 | 69 | 70 | 91 | 45 | 34 | 56 | 12 | 45 | 32 | 69 | ||
6 | 4 | SALEM ALI | 37 | 70 | 71 | 92 | 45 | 76 | 24 | 10 | 81 | 37 | 70 | ||
7 | 5 | SALEM OMAR | 38 | 71 | 72 | 93 | 45 | 45 | 90 | 11 | 82 | 38 | 71 | ||
3 |
sheet result
r.xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | ITEM | NAME | CASE | 1% SUIT | UNITED TAXES | TAX1 | |||
2 | PAID | UNPAID | |||||||
3 | 1 | ALI MOHAMEED | 72 | 201 | 38 | 71 | |||
4 | 2 | ABDULQASEM | 3 | 3 | 115 | 90 | 148 | ||
5 | 3 | ALSA ALDEEF | 24 | 10 | 121 | 97 | 134 | ||
6 | 4 | AHMED OMAR | 90 | 11 | 185 | 67 | 101 | ||
7 | 5 | MOHAMMED ALI | 87 | 12 | 110 | 103 | 79 | ||
8 | 6 | MAHMOUD | 45 | 13 | 14 | 46 | 34 | ||
9 | 7 | SALEM ALI | 71 | 92 | 81 | 37 | 70 | ||
10 | 8 | KHALID ALI | 88 | 11 | 14 | 46 | 34 | ||
result |