Sort and Filter

[prodgerson]

Hello,

I am working with data from two reports at work, one is MS Note Pad and the other is a company system report. I have imported the information from Note Pad into Excel.

The data I now have in Excel is the following;

Customer Purchase Order Number
Customer Name
My company’s part number
Quantity required for each Customer Purchase Order Number

My question is how do I sort this information so that I can see 1) the report sorted by part number from lowest to highest 2) see the customer name for each part number and the quantity on that order 3) a total for that part number required on all orders.

I want the Excel report to look like this:

PO no. Customer Name Part Number Qty

16911955 SAFEWAY PORTLAND 0004142-015 9
16914908 SAFEWAY STOCKTON 0004142-015 14

23

Any help would be appreciated

[teylyn]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!