Finding multiple lines of information in a pivot table

[bobmanboom]

Good morning! First time poster hoping that someone can help! My Excel skills are somewhere between beginner to intermediate I would say.

Overview (sorry trying not to give too much away): The company I work at stocks 10,000 products but a customer of ours lists 3000 of them on their website. I need to find out which 200 products we want to remove from their website to replace with new lines. I thought that the best way to decide would be to use our OLAP reports to see which of the 3000 products that the customer lists sells the least per week, then remove the worst performing 200 products.

Our OLAP populates as a pivot table so I thought that I would just copy and paste the 3000 product codes in to the search bar to see the sales figures and then do an IF formula to see which ones were performing worst or sort it from smallest to biggest sales per week.

It seems I cant search for multiple product codes and have to type them all in individually and press "add to selection" everytime.

This is going to day me forever unless someone can suggest a better way!? Hope this makes sense.

Thanks all for any help in advance

[NeedForExcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

If you cant attach a workbook, then atleast a screenshot to understand what exactly you are referring to..