Excel VBA Code for Auto Increment Values

Good Day!! Can Someone Please Help Me Figure Out how to solve this problem? Thanks


Scenario 1

A11 = 50 this acts as input box

So I want A12 and the rest column of A must be incremented by 30 then once numbers approached on 100, the next is back to 1 plus the over of 100

A12 = 80
A13 = 10
A14 = 40
A15 = 70
A16 = 100
A17 = 30
A18 = 60



Scenario 2

A11 = 1 this acts as input box

So I want A12 and the rest column of A must be incremented by 30 then once numbers approached on 100, the next is back to 1 plus the over of 100

A12 = 31
A13 = 61
A14 = 91
A15 = 21
A16 = 51
A17 = 81
A18 = 11



So i want sir that any number i put on A11, the next column must be automatic increment of 30

Please Login or Register  to view this content.

In above code what I do is have a pointer to A column & 12 row. Pointer pointing to 12 row is incremented this is done via For Loop.

Within For loop I have a condition any value above 100 will restart from 10 digit & based on last digit will be retained.
This is done using concatenation operator &.

If it is not 100 then add 30 with previous row contents.

Hope this helps
___________________________________________________________________________________________________________________________
Please click * to say thank You

Increment.xlsm
Please See Attached Sample Sir

Originally Posted by shyamhappy

Please Login or Register  to view this content.

In above code what I do is have a pointer to A column & 12 row. Pointer pointing to 12 row is incremented this is done via For Loop.

Within For loop I have a condition any value above 100 will restart from 10 digit & based on last digit will be retained.
This is done using concatenation operator &.

If it is not 100 then add 30 with previous row contents.

Hope this helps
___________________________________________________________________________________________________________________________
Please click * to say thank You

it works sir but the amounts were the same/ repetitive!

It is based on what input you have put on the A12 cell.

Based on it the values gets incrementing, Please can you tell after first sequence what sequence you are expecting

Please See Attached File Sir Above

Please Login or Register  to view this content.

Please try this code, this will work for you.

Originally Posted by shyamhappy

Please Login or Register  to view this content.

Please try this code, this will work for you.

its not getting what i wanted sir!

Please try this macro & let me know if you need any amendments.


___________________________________________________________________________________________________
Please click * to say thank you.