How do I alpha short worksheets in a workbook:

[efward1]

In a workbook I have many worksheets named with employee names. I want to
rearrange all the worksheets so that they are in alpha order.

[Dave Peterson]

You could use a macro:

Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm

David McRitchie's:
http://www.mvps.org/dmcritchie/excel...#sortallsheets

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

efward1 wrote:
>
> In a workbook I have many worksheets named with employee names. I want to
> rearrange all the worksheets so that they are in alpha order.

--

Dave Peterson

[efward1]

It has been 6 years since I worked in Excel. I use to sort the worksheets in
a workbook without the use of a macro. I just can't remember how the action
is performed. I know there is a simply way to do it without macros.

"Dave Peterson" wrote:

> You could use a macro:
>
> Chip Pearson's:
> http://www.cpearson.com/excel/sortws.htm
>
> David McRitchie's:
> http://www.mvps.org/dmcritchie/excel...#sortallsheets
>
> If you're new to macros, you may want to read David McRitchie's intro at:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
> efward1 wrote:
> >
> > In a workbook I have many worksheets named with employee names. I want to
> > rearrange all the worksheets so that they are in alpha order.
>
> --
>
> Dave Peterson
>

[Dave Peterson]

You can click and drag the worksheet tabs to whereever you like.

efward1 wrote:
>
> It has been 6 years since I worked in Excel. I use to sort the worksheets in
> a workbook without the use of a macro. I just can't remember how the action
> is performed. I know there is a simply way to do it without macros.
>
> "Dave Peterson" wrote:
>
> > You could use a macro:
> >
> > Chip Pearson's:
> > http://www.cpearson.com/excel/sortws.htm
> >
> > David McRitchie's:
> > http://www.mvps.org/dmcritchie/excel...#sortallsheets
> >
> > If you're new to macros, you may want to read David McRitchie's intro at:
> > http://www.mvps.org/dmcritchie/excel/getstarted.htm
> >
> > efward1 wrote:
> > >
> > > In a workbook I have many worksheets named with employee names. I want to
> > > rearrange all the worksheets so that they are in alpha order.
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

[efward1]

Thank you for your help, I will do it that way for now. Also,
could you help me figure out an formula for the following:

if B6 is equal to OR greater than I4, then.......

I how how to do an "IF" formula,,,but I do not know how to do one with
"equal to or greater than" (at the same time)

Thanks
Faye




"Dave Peterson" wrote:

> You can click and drag the worksheet tabs to whereever you like.
>
> efward1 wrote:
> >
> > It has been 6 years since I worked in Excel. I use to sort the worksheets in
> > a workbook without the use of a macro. I just can't remember how the action
> > is performed. I know there is a simply way to do it without macros.
> >
> > "Dave Peterson" wrote:
> >
> > > You could use a macro:
> > >
> > > Chip Pearson's:
> > > http://www.cpearson.com/excel/sortws.htm
> > >
> > > David McRitchie's:
> > > http://www.mvps.org/dmcritchie/excel...#sortallsheets
> > >
> > > If you're new to macros, you may want to read David McRitchie's intro at:
> > > http://www.mvps.org/dmcritchie/excel/getstarted.htm
> > >
> > > efward1 wrote:
> > > >
> > > > In a workbook I have many worksheets named with employee names. I want to
> > > > rearrange all the worksheets so that they are in alpha order.
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

[Dave Peterson]

=if(b6>=i4,"greater than or equal","less than")



efward1 wrote:
>
> Thank you for your help, I will do it that way for now. Also,
> could you help me figure out an formula for the following:
>
> if B6 is equal to OR greater than I4, then.......
>
> I how how to do an "IF" formula,,,but I do not know how to do one with
> "equal to or greater than" (at the same time)
>
> Thanks
> Faye
>
> "Dave Peterson" wrote:
>
> > You can click and drag the worksheet tabs to whereever you like.
> >
> > efward1 wrote:
> > >
> > > It has been 6 years since I worked in Excel. I use to sort the worksheets in
> > > a workbook without the use of a macro. I just can't remember how the action
> > > is performed. I know there is a simply way to do it without macros.
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > You could use a macro:
> > > >
> > > > Chip Pearson's:
> > > > http://www.cpearson.com/excel/sortws.htm
> > > >
> > > > David McRitchie's:
> > > > http://www.mvps.org/dmcritchie/excel...#sortallsheets
> > > >
> > > > If you're new to macros, you may want to read David McRitchie's intro at:
> > > > http://www.mvps.org/dmcritchie/excel/getstarted.htm
> > > >
> > > > efward1 wrote:
> > > > >
> > > > > In a workbook I have many worksheets named with employee names. I want to
> > > > > rearrange all the worksheets so that they are in alpha order.
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson