Auto increment a cell and loop

[dilanhj]

Hi Guys,

Can anyone help me write a formula to auto increment a cell when sheet is auto refreshed/saved. Incremental number should start with "1" and increment till "10" and loop back once again to "1". the number returned will be used to lookup up a row.

I did used a formula with rand() function which is "=INT(RAND()*(10-1)+1)" and it returns a random number from the range 1 to 10.

Regards
Dilan

 

[James006]

Hi,

There is no need for a formula ...if there is a precise event which should trigger the increment ...

Indeed, an event macro can handle these situations

Hope this will help

 

[dilanhj]

Hi,

There is no need for a formula ...if there is a precise event which should trigger the increment ...

Indeed, an event macro can handle these situations

Hope this will help

Hi James,

I need a help on this. Im slightly good with formulas. but not good with macros or VBA

Regards
Dilan