| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need really fast method to sort data for my part numbering spread
I have a part numbering spreadsheet for my manufacturing business. Columns
a Part #, Description, Mfg P/N, Mfg Name, Cost, weblink, etc. There is one header row with above descriptions. I typically need to sort by Part # or Description. Is there are really quick way to run the sort function. I love it to be one or two mindless clicks. Thanks, Chris |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need really fast method to sort data for my part numbering spread
What happened when you tried it?
Sort will remember the parameters you give it, so after you've done it the first time, you should be able to repeat it with one or two clicks. If you need further help, post back with the version of Excel you are using. Regards, Fred "Chris Dundorf" <Chris wrote in message ... I have a part numbering spreadsheet for my manufacturing business. Columns a Part #, Description, Mfg P/N, Mfg Name, Cost, weblink, etc. There is one header row with above descriptions. I typically need to sort by Part # or Description. Is there are really quick way to run the sort function. I love it to be one or two mindless clicks. Thanks, Chris |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need really fast method to sort data for my part numbering spread
Hi Chris.
I have just put up an EXCEL 2007 file for you at:- http://www.pierrefondes.com/ - item number 75 towards the top of my home page. All you have to do is to click the filter buttons in the top row to get what you want. If my comments have helped please hit Yes. Thanks. "Chris Dundorf" wrote: I have a part numbering spreadsheet for my manufacturing business. Columns a Part #, Description, Mfg P/N, Mfg Name, Cost, weblink, etc. There is one header row with above descriptions. I typically need to sort by Part # or Description. Is there are really quick way to run the sort function. I love it to be one or two mindless clicks. Thanks, Chris |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need really fast method to sort data for my part numbering spr
trip_to_tokyo,
What you created is exactly what I'm looking for. Please tell me how to make the drop-down soting tools appear near the top of each column. Thanks, Chris "trip_to_tokyo" wrote: Hi Chris. I have just put up an EXCEL 2007 file for you at:- http://www.pierrefondes.com/ - item number 75 towards the top of my home page. All you have to do is to click the filter buttons in the top row to get what you want. If my comments have helped please hit Yes. Thanks. "Chris Dundorf" wrote: I have a part numbering spreadsheet for my manufacturing business. Columns a Part #, Description, Mfg P/N, Mfg Name, Cost, weblink, etc. There is one header row with above descriptions. I typically need to sort by Part # or Description. Is there are really quick way to run the sort function. I love it to be one or two mindless clicks. Thanks, Chris |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need really fast method to sort data for my part numbering spr
trip_to_tokyo,
What you created is exactly what I'm looking for. Please tell me how to make the drop-down sorting tools appear near the top of each column. Thanks, Chris "trip_to_tokyo" wrote: Hi Chris. I have just put up an EXCEL 2007 file for you at:- http://www.pierrefondes.com/ - item number 75 towards the top of my home page. All you have to do is to click the filter buttons in the top row to get what you want. If my comments have helped please hit Yes. Thanks. "Chris Dundorf" wrote: I have a part numbering spreadsheet for my manufacturing business. Columns a Part #, Description, Mfg P/N, Mfg Name, Cost, weblink, etc. There is one header row with above descriptions. I typically need to sort by Part # or Description. Is there are really quick way to run the sort function. I love it to be one or two mindless clicks. Thanks, Chris |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need really fast method to sort data for my part numbering spr
Hi Fred,
I'm running Office 2007. I just replied to "trip-to_tokyo" saying that his example spread sheet has the drop-down sorting tool that I'm looking (2 clicks to sort any column...) for but that I don't know how he created the tool so that they stay near the top of the column. My data sorting doesn't appear to remember what I did., in that I need to go up to the Data tab Sort then select the cells to sort and type of sorting to perform. Chris "Fred Smith" wrote: What happened when you tried it? Sort will remember the parameters you give it, so after you've done it the first time, you should be able to repeat it with one or two clicks. If you need further help, post back with the version of Excel you are using. Regards, Fred "Chris Dundorf" <Chris wrote in message ... I have a part numbering spreadsheet for my manufacturing business. Columns a Part #, Description, Mfg P/N, Mfg Name, Cost, weblink, etc. There is one header row with above descriptions. I typically need to sort by Part # or Description. Is there are really quick way to run the sort function. I love it to be one or two mindless clicks. Thanks, Chris . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need really fast method to sort data for my part numbering spr
See "filter"
Chris Dundorf wrote: trip_to_tokyo, What you created is exactly what I'm looking for. Please tell me how to make the drop-down soting tools appear near the top of each column. Thanks, Chris "trip_to_tokyo" wrote: Hi Chris. I have just put up an EXCEL 2007 file for you at:- http://www.pierrefondes.com/ - item number 75 towards the top of my home page. All you have to do is to click the filter buttons in the top row to get what you want. If my comments have helped please hit Yes. Thanks. "Chris Dundorf" wrote: I have a part numbering spreadsheet for my manufacturing business. Columns a Part #, Description, Mfg P/N, Mfg Name, Cost, weblink, etc. There is one header row with above descriptions. I typically need to sort by Part # or Description. Is there are really quick way to run the sort function. I love it to be one or two mindless clicks. Thanks, Chris |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need really fast method to sort data for my part numbering spr
It's a Data Filter.
If your data is well managed (doesn't have any blank rows or columns), highlight the top row, then use DataFilter. If your data has blanks in it, highlight the entire table, then use DataFilter. Regards, Fred "Chris Dundorf" wrote in message ... trip_to_tokyo, What you created is exactly what I'm looking for. Please tell me how to make the drop-down soting tools appear near the top of each column. Thanks, Chris "trip_to_tokyo" wrote: Hi Chris. I have just put up an EXCEL 2007 file for you at:- http://www.pierrefondes.com/ - item number 75 towards the top of my home page. All you have to do is to click the filter buttons in the top row to get what you want. If my comments have helped please hit Yes. Thanks. "Chris Dundorf" wrote: I have a part numbering spreadsheet for my manufacturing business. Columns a Part #, Description, Mfg P/N, Mfg Name, Cost, weblink, etc. There is one header row with above descriptions. I typically need to sort by Part # or Description. Is there are really quick way to run the sort function. I love it to be one or two mindless clicks. Thanks, Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbering rows in a simple spread sheet | Excel Discussion (Misc queries) | |||
| Creating part # tags using sequential numbering. | Excel Discussion (Misc queries) | |||
| Data Sort 2 part question | Excel Discussion (Misc queries) | |||
| How do I sort entire spread sheet. Names w/data | Excel Worksheet Functions | |||
| ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. | New Users to Excel | |||
Linear Mode
