Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a drop-down menu to sort data?
Hi! I use Microsoft Office 2003. A part of my job is to maintain a
spreadsheet containing data on vehicles my company owns & rents. It looks a little something like this: unit no. --- VIN --- plate no. --- year --- make --- model --- cost (data goes in cells underneath column titles above) What I want to do is have a drop-down menu that will take all that data and allow the user to sort its order of precedence in the list by unit number, or year, or cost, etc. How would I go about doing that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a drop-down menu to sort data?
If you're using xl2003 (or higher), you can apply data|filter|autofilter.
There's an option under each arrow that allows you to sort the filtered range by that field. If you're using xl2002 or below (or any version of excel, really), you can use a technique at Debra Dalgleish's site: http://contextures.com/xlSort02.html Katalio wrote: Hi! I use Microsoft Office 2003. A part of my job is to maintain a spreadsheet containing data on vehicles my company owns & rents. It looks a little something like this: unit no. --- VIN --- plate no. --- year --- make --- model --- cost (data goes in cells underneath column titles above) What I want to do is have a drop-down menu that will take all that data and allow the user to sort its order of precedence in the list by unit number, or year, or cost, etc. How would I go about doing that? -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a drop-down menu to sort data?
That was actually a big help in pointing me in the right direction. The only
thing I would like to add is that on this page there are multiple charts following that same format on the same page, stacked one over the other with only a blank line separating each one. How do I keep the sorting contained to a specific range of cells? "Dave Peterson" wrote: If you're using xl2003 (or higher), you can apply data|filter|autofilter. There's an option under each arrow that allows you to sort the filtered range by that field. If you're using xl2002 or below (or any version of excel, really), you can use a technique at Debra Dalgleish's site: http://contextures.com/xlSort02.html Katalio wrote: Hi! I use Microsoft Office 2003. A part of my job is to maintain a spreadsheet containing data on vehicles my company owns & rents. It looks a little something like this: unit no. --- VIN --- plate no. --- year --- make --- model --- cost (data goes in cells underneath column titles above) What I want to do is have a drop-down menu that will take all that data and allow the user to sort its order of precedence in the list by unit number, or year, or cost, etc. How would I go about doing that? -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a drop-down menu to sort data?
The code either sorts the autofilter range or determines the last row of the
range to be sorted by using: LastRow = .Cells(.Rows.Count, strCol).End(xlUp).Row (strCol is "A" in the sample code) Any embedded chart won't change this list row. If you have data in rows after the table to be sorted, then that would cause trouble. But you haven't shared enough information to help (for me, at least). Katalio wrote: That was actually a big help in pointing me in the right direction. The only thing I would like to add is that on this page there are multiple charts following that same format on the same page, stacked one over the other with only a blank line separating each one. How do I keep the sorting contained to a specific range of cells? "Dave Peterson" wrote: If you're using xl2003 (or higher), you can apply data|filter|autofilter. There's an option under each arrow that allows you to sort the filtered range by that field. If you're using xl2002 or below (or any version of excel, really), you can use a technique at Debra Dalgleish's site: http://contextures.com/xlSort02.html Katalio wrote: Hi! I use Microsoft Office 2003. A part of my job is to maintain a spreadsheet containing data on vehicles my company owns & rents. It looks a little something like this: unit no. --- VIN --- plate no. --- year --- make --- model --- cost (data goes in cells underneath column titles above) What I want to do is have a drop-down menu that will take all that data and allow the user to sort its order of precedence in the list by unit number, or year, or cost, etc. How would I go about doing that? -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a drop-down menu to sort data?
Hi,
Not entirely clear what your data looks like, but to sort a specific range in Excel, select the range, say A25:D55 and choose Data, Sort, specify the field you want to sort on and then indicate that there is No Header Row. This assumes that A25:D55 is part of a larger range A1:D1000 for example. -- Thanks, Shane Devenshire "Katalio" wrote: That was actually a big help in pointing me in the right direction. The only thing I would like to add is that on this page there are multiple charts following that same format on the same page, stacked one over the other with only a blank line separating each one. How do I keep the sorting contained to a specific range of cells? "Dave Peterson" wrote: If you're using xl2003 (or higher), you can apply data|filter|autofilter. There's an option under each arrow that allows you to sort the filtered range by that field. If you're using xl2002 or below (or any version of excel, really), you can use a technique at Debra Dalgleish's site: http://contextures.com/xlSort02.html Katalio wrote: Hi! I use Microsoft Office 2003. A part of my job is to maintain a spreadsheet containing data on vehicles my company owns & rents. It looks a little something like this: unit no. --- VIN --- plate no. --- year --- make --- model --- cost (data goes in cells underneath column titles above) What I want to do is have a drop-down menu that will take all that data and allow the user to sort its order of precedence in the list by unit number, or year, or cost, etc. How would I go about doing that? -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a drop-down menu to sort data?
Perfect, thanks everyone!
"ShaneDevenshire" wrote: Hi, Not entirely clear what your data looks like, but to sort a specific range in Excel, select the range, say A25:D55 and choose Data, Sort, specify the field you want to sort on and then indicate that there is No Header Row. This assumes that A25:D55 is part of a larger range A1:D1000 for example. -- Thanks, Shane Devenshire "Katalio" wrote: That was actually a big help in pointing me in the right direction. The only thing I would like to add is that on this page there are multiple charts following that same format on the same page, stacked one over the other with only a blank line separating each one. How do I keep the sorting contained to a specific range of cells? "Dave Peterson" wrote: If you're using xl2003 (or higher), you can apply data|filter|autofilter. There's an option under each arrow that allows you to sort the filtered range by that field. If you're using xl2002 or below (or any version of excel, really), you can use a technique at Debra Dalgleish's site: http://contextures.com/xlSort02.html Katalio wrote: Hi! I use Microsoft Office 2003. A part of my job is to maintain a spreadsheet containing data on vehicles my company owns & rents. It looks a little something like this: unit no. --- VIN --- plate no. --- year --- make --- model --- cost (data goes in cells underneath column titles above) What I want to do is have a drop-down menu that will take all that data and allow the user to sort its order of precedence in the list by unit number, or year, or cost, etc. How would I go about doing that? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ho Do I create drop down menu? | Excel Worksheet Functions | |||
How do you create a drop down menu in excel? | Excel Worksheet Functions | |||
In Excel 2003 SP1, "sort" on the Data drop-down menu is grayed ou. | Excel Worksheet Functions | |||
how do I create a drop down menu in Excell? | Excel Worksheet Functions | |||
how do i create drop down menu in excel | Excel Worksheet Functions |