Autofill- Reversing Order

I would like to auto fill plan sheets numbered '1/5, 2/5, 3/5' etc.

Reversing the order to '5/1, 5/2, 5/3' etc. works but I want to keep them
in their original order if possible.

Is there a way?
TIA

Hi,

If '5/1, 5/2, 5/3' is in Cell A1 then in B1 enter =ReverseCell(A2,TRUE).

You need to add the VBA code to the sheet first to work

http://www.ozgrid.com/VBA/ReverseCell.htm

VBA Noob

Format your starting cell as Comma Style and enter 1/5. It should display 1/5
in the cell and 0.2 in the Formula bar. Select Edit >> Fill >> Series. Select
data in Columns, Step Value = .2, Stop Value = the final value you want in
the series, and click OK.

Hope this helps,

Hutch

"Earl" wrote:

> I would like to auto fill plan sheets numbered '1/5, 2/5, 3/5' etc.
>
> Reversing the order to '5/1, 5/2, 5/3' etc. works but I want to keep them
> in their original order if possible.
>
> Is there a way?
> TIA

Tom

Maybe Comma style should be Fraction from Format>Cells>Number


Gord Dibben MS Excel MVP

On Mon, 31 Jul 2006 13:42:02 -0700, Tom Hutchins
<TomHutchins@discussions.microsoft.com> wrote:

>Format your starting cell as Comma Style and enter 1/5. It should display 1/5
>in the cell and 0.2 in the Formula bar. Select Edit >> Fill >> Series. Select
>data in Columns, Step Value = .2, Stop Value = the final value you want in
>the series, and click OK.
>
>Hope this helps,
>
>Hutch
>
>"Earl" wrote:
>
>> I would like to auto fill plan sheets numbered '1/5, 2/5, 3/5' etc.
>>
>> Reversing the order to '5/1, 5/2, 5/3' etc. works but I want to keep them
>> in their original order if possible.
>>
>> Is there a way?
>> TIA

Makes sense, although Comma Style worked for me.

Regards,

Hutch

"Gord Dibben" wrote:

> Tom
>
> Maybe Comma style should be Fraction from Format>Cells>Number
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 31 Jul 2006 13:42:02 -0700, Tom Hutchins
> <TomHutchins@discussions.microsoft.com> wrote:
>
> >Format your starting cell as Comma Style and enter 1/5. It should display 1/5
> >in the cell and 0.2 in the Formula bar. Select Edit >> Fill >> Series. Select
> >data in Columns, Step Value = .2, Stop Value = the final value you want in
> >the series, and click OK.
> >
> >Hope this helps,
> >
> >Hutch
> >
> >"Earl" wrote:
> >
> >> I would like to auto fill plan sheets numbered '1/5, 2/5, 3/5' etc.
> >>
> >> Reversing the order to '5/1, 5/2, 5/3' etc. works but I want to keep them
> >> in their original order if possible.
> >>
> >> Is there a way?
> >> TIA
>
>