Lookup and Sort Question

J

Josh O.

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?
 
J

Josh O.

Frank,
Forgive me, I don't see how that will help put the list in alphabetical
order. I am not familiar at all with the data validation, and only a little
with the vlookup. I have used the lookup function alot.

Can you offer me detail as to how the two functions may help?
 
F

Frank Kabel

Hi Josh
sorry for my misunderstanding. Just a question: You want to do this
with formulas?. Why not use Excel's sort feature?
 
T

Tom Ogilvy

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

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

Josh O.

My final objective is to set up a spreadsheet that I can just open and print
without having to format and move around. I am trying to fit 200 to 300
customers onto one sheet of paper as a reference list.

If I do everything in one column, I don't have any way to fit it onto on
shee that is readable. Let me know what you think.

For Example:
Customer Number | Customer Name | Customer Number | Customer Name ...
847300001 | Customer 1 | 847300100 |
Customer 100
847300002 | Customer 2 | 847300101 |
Customer 101
847300003 | Customer 3 | 847300102 |
Customer 102
....and so on.

If you have any other ideas how to handle this, let me know.
 
J

Josh O.

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.
 
Top