|
Lookup and Sort Question
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? |
| All times are GMT +1. The time now is 02:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com