Pull out all summary data per customer

[pamela16]

Hi
As you can see I have the 'Customer Data' sheet where I put all the items bought for each customers that were ordered from rows J to AL. Now, on 'Parts Summary', what I would like to achieve is when I put the machine no. eg 4354 I would like to get summary of all items for that specific customer.

Please help. Thank you.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...ml#post5200670