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?