Autofill- Reversing Order

[Guest]

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

 

[VBA Noob]

Hi,

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

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

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

VBA Noo

 

[Guest]

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

 

[Gord Dibben]

Tom

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


Gord Dibben MS Excel MVP

 

[Guest]

Makes sense, although Comma Style worked for me.

Regards,

Hutch