bring and sum data across multiple sheets

[ABDELFATTA]

hello
i look for way sum values for brands across multiple sheets and bring all of data i put expected result in sheet(result)

[alansidman]

Using Power Query which is available in Excel 2010 as an add in.

Bring both tables into PQ Editor.
Append each to the other
Group on the Sub Column to sum the value column

File attached for your review.

[ABDELFATTA]

thanks alansidman actually i'm not good at pow query i prefer do that by macro with use function sum or sumif

[alansidman]

No worries. You may want to try and learn this as it makes life easier. Here is a 9 minute tutorial that will walk you through the first part of your issue. Surprisingly simple to do.

https://www.youtube.com/watch?v=pVln...0s&app=desktop

[bakerman2]

For starters.

Please Login or Register  to view this content.

[ABDELFATTA]

well done ! bakerman i would make more dynamic and loop without any empty cell to avoid slowly the code
i try do this

but it takes more time

[bakerman2]

Try this way.

Please Login or Register  to view this content.

[ABDELFATTA]

yes it's better many thanks for you and alansidman

[bakerman2]

You're welcome and thanks for rep+.

[alansidman]

Thanks for the Rep