I have never used a pivot table, so I am not sure. Either way I just
recorded a macro to do what I want until I can figure out a more efficient
way to handle.

"Tom Ogilvy" wrote:

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?