Help with tracking

[AndrewD04]

Hi, firstly thank you for any help.
I am building a tracker that I need help with a formula I want a cell to increase by one for every 5 increment in another cell.

 

[Trouttrap2]

Here is what i came up with.
Excel 2010#FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB">#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">

	A	B
Number	Increment

<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

</tbody>

#DAE7F5 ;color: #161120">Sheet2​

#FFFFFF " >[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas#FFFFFF ;border-collapse: collapse; border-color: #BBB">#DAE7F5 ;color: #161120">[TABLE="width: 100%"]
<thead>[TR="bgcolor: <a href="]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: <a href="]#DAE7F5 ;color: #161120">B2[/TH]
[TD="align: left"]=INT(A2/5)[/TD]
[/TR]
</tbody>[/TABLE]

I guess my HTML maker isn't working.....[/TD]
[/TR]
</tbody>[/TABLE]

 

[AndrewD04]

Here is what i came up with.
Excel 2010#FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB">#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">

	A	B
Number	Increment

<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

</tbody>

#DAE7F5 ;color: #161120">Sheet2​

#FFFFFF " >[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas#FFFFFF ;border-collapse: collapse; border-color: #BBB">#DAE7F5 ;color: #161120">[TABLE="width: 100%"]
<thead>[TR="bgcolor: <a href="]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: <a href="]#DAE7F5 ;color: ">B2[/TH]
[TD="align: left"]=INT(A2/5)[/TD]
[/TR]
</tbody>[/TABLE]

I guess my HTML maker isn't working.....[/TD]
[/TR]
</tbody>[/TABLE]

Perfect ? thank you

 

[AndrewD04]

Does anyone know how to carry over a number from one sheet to another for example.

I have a cell increasing ( C2)and another C3 which adds 1 for every 5 in cell C2 however I want it to carry over anything out of 5 on to another sheet so if there is 12 it will carry over the 2

 

[Trouttrap2]

I think this is what you are wanting?

=MOD(C2,5)