Prev: need to do a look up from another sheet
Next: Summary worksheet within a workbook
From: Chris Dundorf Chris on 23 Mar 2010 15:00
I have a part numbering spreadsheet for my manufacturing business. Columns
are: 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
From: Fred Smith on 23 Mar 2010 15:25
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 Dundorf(a)discussions.microsoft.com> wrote in message
news:5309365E-752A-486D-AD1B-16053B5D3004(a)microsoft.com...
>I have a part numbering spreadsheet for my manufacturing business. Columns
> are: 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

From: trip_to_tokyo on 23 Mar 2010 15:36
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
> are: 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
 | 
Pages: 1
Prev: need to do a look up from another sheet
Next: Summary worksheet within a workbook