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

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

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

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

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

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

.

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

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