hwo to track the same number from another worksheet

[Adamlearnexcel]

Hi, Sir.
every time my workers will enter lots of part numbers into excel sheet. I need to generate a report which contains the quantity and series number of every product.

For example: when they scan a product, excel sheet will show part number and series number into two columns. I need to track all products' information into my summary sheet. when a product have one part number but two series number, they need to scan for twice. but in my summary sheet, i need to show product quantity which is 2, and series number.
how can I do this ?

[:) Sixthsense :)]

It will be helpful to us to give exact solution for your query if you attach a sample workbook with expected output by describing the method to achieve it.

[Adamlearnexcel]

It will be helpful to us to give exact solution for your query if you attach a sample workbook with expected output by describing the method to achieve it.

Sir, This is the sample workbook, in the scanning, I highlight the same number, this number will be scam twice. because the series number start with 91 is different. however, in my inner packing list, I want this number appear one tiem and the quantity will be 2, and last column display two series number, how should I do this ?
Thank you so much

[:) Sixthsense :)]

last column display two series number, how should I do this ?

If just needs to show only the 2 series of numbers then its possible in using excel's inbuilt worksheet functions. but number of items increases based on the data then showing all in a single cell by matching the condition is not possible without the help of VBA Code.

Please confirm.

[Adamlearnexcel]

If just needs to show only the 2 series of numbers then its possible in using excel's inbuilt worksheet functions. but number of items increases based on the data then showing all in a single cell by matching the condition is not possible without the help of VBA Code.

Please confirm.

Yup, I want to show both the number of items and series number in inner packing list base on the result in scanning list. so how should I use VBA to do this, is going to be very complicated?

[:) Sixthsense :)]

Check the below link to know how to add the code in Standard Module
http://www.contextures.com/xlvba01.html

Please Login or Register  to view this content.

=CLookup(LookupValue,LookupRange,ResultRange)

In D6 cell of Inner Packing List Sheet

Please Login or Register  to view this content.

In D6 cell of Inner Packing List Sheet for getting the count of quantity

Please Login or Register  to view this content.

Drag it down.

Refer the attached excel for details.

[Adamlearnexcel]

Sir, I remove alr.
wa, this is amazing, I saw the beauty of excel VBA. now the problem is that I only want to show one line of "3BDH000382R0001" with quantity 2 and two series number in inner packing list.. how chould I edit? Thank you so much, sir.

[:) Sixthsense :)]

Please remove all the quotes from all of your above posts since it is against forum rule # 12

12. Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

[Adamlearnexcel]

Thank you for you reminder. I removed the quotes alr
Sir, could you look my older post again, I still got one problem.

[:) Sixthsense :)]

Make use of the below code developed by jindon who had solved this kind of query earlier.

Please Login or Register  to view this content.

Return to excel and copy and paste the below formula in Article #

Please Login or Register  to view this content.

Drag the formula down...

[Adamlearnexcel]

Sir, I used the code you have posted, it works~!!! Thank you so much....
But I am not quite understand the logic behind.
How to learn VBA language, do you have any tips?
Is is going to be a tough journey?
Thank you so much......