Will a pivot table report do what you want? (Data= Pivot Table)

The advanced filter (Data=Filter=Advanced Filter, then sort)

--
Regards,
Tom Ogilvy

"Josh O." wrote in message
...
I am trying to make a spreadsheet with a customer list that pulls a
customer
number and name from another spreadsheet and places them alphabetically
(with
corresponding customer number) onto the spreadsheet I am using.

Is there a way to do this?