Hi experts
i need auto list of code from sheet2 & sheet 3 & sum of value aga respective codes.
I have attached sample file
please urgently reply.
Thanks in advance for solving my thread
regards
nilesh zala
Hi experts
i need auto list of code from sheet2 & sheet 3 & sum of value aga respective codes.
I have attached sample file
please urgently reply.
Thanks in advance for solving my thread
regards
nilesh zala
With the little information you have supplied, I believe that you want to use the Data--->Consolidate function.
http://technet.microsoft.com/en-us/l.../cc750889.aspx
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I want list of codes in sheet1 form other sheet & sum of value against respective codes
for example
code sum
d0052 794426
e0001 73544
Try the attached. There is a button on sheet1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks