increment in excel

Good Afternoon everyone! I need help a macro that increments correctly. The macro i'm trying to tweak is meant to copy the activesheet, and paste the duplicate with the old name and the revision number. i.e.: ORC01 to ORC01_R1 since this macro is applied to a button on the activesheet, it...

I am trying to generate a sequence of incremented integers where some are known and some are populated randomly within a sequence construct. For example: #<10<#<#<20<#<#<30<<<100 <#<#<1010, etc. The idea is that each of the "#" is replaced with a unique integer that is greater than the...

If date of joining falls between 2nd January to 30th June, date of increment will be 1st July next year but if date of joining falls between 1st July to 1st January, date of increment will be the date of joining next yearFor example, if the date of joining be 25 January, 2001, date of increment...