copy data from multiple sheets to one sheet based on dropdown and summing values

Alaa mg

Active Member
Joined
May 29, 2021
Messages
375
Office Version
  1. 2019
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

1.xlsm
ABCDEFGHIJKLM
1ITEMNAMENUMBERS OF HOURSWAGESCASE0.120.031.001.001% SUITUNITED TAXESTAX1
2PAIDUNPAID
31ALI MOHAMEED11121111644511
42ABDULQASEM12233333757833
53ALSA ALDEEF 552410813790348778
64AHMED OMAR66901182381021871056
75MOHAMMED ALI77871283391113985745
86MAHMOUD88451384401234144634
1


sheet2
2.xlsm
ABCDEFGHIJKLM
1ITEMNAMENUMBERS OF HOURSWAGESCASE0.120.031.001.001% SUITUNITED TAXESTAX1
2PAIDUNPAID
31ALI MOHAMEED333333757833
42ABDULQASEM45762410813790348778
53ALSA ALDEEF 4545901182381021871056
64AHMED OMAR4534871283391113985745
75MOHAMMED ALI4534451384401234124634
86KHALID ALI224788111020301004634
2

sheet3
3.xlsm
ABCDEFGHIJKLM
1ITEMNAMENUMBERS OF HOURSWAGESCASE0.120.031.001.001% SUITUNITED TAXESTAX1
2PAIDUNPAID
31ALI MOHAMEED3467688990675467783467
42ABDULQASEM356869903333330
53MAHMOUD SALEM3669709145345612453269
64SALEM ALI3770719245762410813770
75SALEM OMAR3871729345459011823871
3

sheet result
r.xlsm
ABCDEFG
1ITEMNAMECASE1% SUITUNITED TAXESTAX1
2PAIDUNPAID
31ALI MOHAMEED722013871
42ABDULQASEM3311590148
53ALSA ALDEEF 241012197134
64AHMED OMAR901118567101
75MOHAMMED ALI871211010379
86MAHMOUD4513144634
97SALEM ALI7192813770
108KHALID ALI8811144634
result
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
sorry I forgot add an important detail , the dropdown by data validation in J2 linked with COL B in sheet result also if I s elect specific name then should merge and sum the only selected from dropdown and if the dropdown is empty then merge and sum all the names
r.xlsm
ABCDEFGHIJ
1ITEMNAMECASE1% SUITUNITED TAXESTAX1
2PAIDUNPAID
31ALI MOHAMEED722013871
42ABDULQASEM3311590148
53ALSA ALDEEF 241012197134
64AHMED OMAR901118567101
75MOHAMMED ALI871211010379
86MAHMOUD4513144634
97SALEM ALI7192813770
108KHALID ALI8811144634
result
Cells with Data Validation
CellAllowCriteria
J2List=$B$3:$B$10
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,270
Messages
6,171,103
Members
452,379
Latest member
IainTru

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