Finding/displaying all line items that are on a list of sales orders by order number

[mikeshums]

I'm trying to get my head around a strategy to do this. Excel 2010.

I have a long list of parts shipped with the order number in one of the fields. I've identified a list of order numbers that I want to focus on. I am now trying to create a list by order number, showing the line items for each order.

I can pivot but then have to somehow select the order numbers to filter on. I have hundreds of orders and thousands of parts shipped.

I'm not an SQL user and not an access designer although I have some access experience as a user - not a developer.

Parts Order No
a 100
b 101
c 102
d 101
e 101
a 104
b 102
f 100

the result would show:

Order No:

100 a,f
101 b,d,e
etc.

the end format is not critical, I just need to see all the parts for the list of orders I am focusing on.

thanks!

Mike

 

[sheetspread]

but then have to somehow select the order numbers to filter on. I have hundreds of orders and thousands of parts shipped.

With the advanced filter you just need a range of search criteria

 

[mikeshums]

Advanced filter! I didn't know about that and couldn't seem to frame up the right search terms to get there. THANKS!