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?

Hi
use Data Validation together with VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html
http://www.contextures.com/xlDataVal01.html


--
Regards
Frank Kabel
Frankfurt, Germany

"Josh O." schrieb im Newsbeitrag
...
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?

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?

"Frank Kabel" wrote:

Hi
use Data Validation together with VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html
http://www.contextures.com/xlDataVal01.html


--
Regards
Frank Kabel
Frankfurt, Germany

"Josh O." schrieb im Newsbeitrag
...
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?

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Josh O." schrieb im Newsbeitrag
...
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?

"Frank Kabel" wrote:

Hi
use Data Validation together with VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html
http://www.contextures.com/xlDataVal01.html


--
Regards
Frank Kabel
Frankfurt, Germany

"Josh O." schrieb im Newsbeitrag
...
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?

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?

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.

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Josh O." schrieb im Newsbeitrag
...
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?

"Frank Kabel" wrote:

Hi
use Data Validation together with VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html
http://www.contextures.com/xlDataVal01.html


--
Regards
Frank Kabel
Frankfurt, Germany

"Josh O." schrieb im Newsbeitrag
...
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?

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?

Hi
and how does your source data look like?

You may have a look at:
http://www.mvps.org/dmcritchie/excel/snakecol.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Josh O." schrieb im Newsbeitrag
...
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.

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Josh O." schrieb im Newsbeitrag
...
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?

"Frank Kabel" wrote:

Hi
use Data Validation together with VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html
http://www.contextures.com/xlDataVal01.html


--
Regards
Frank Kabel
Frankfurt, Germany

"Josh O." schrieb im
Newsbeitrag
...
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?