How to increment column value as per previous column and validations

[pan07]

Hi All,

I Require help in creating Macros for Excel sheet . I have a Excel sheet in which there are many numbers of columns. There is duplication of columns too. I am attaching the Excel for Reference.

I want to create Macro for a particular column name “Id” whose first occurrence should be ‘2’ and after that it must increment by 1.
There must be a validation that before setting the “Id” column value, the previous column (left one attached column) must not empty other don’t set the “Id” column Value and check for it’s next occurrence and same validation.

One More Thing as the column numbers can vary means can increase i.e. there is no fix no of “Id” column. So this setting of value should occurs till the last occurrence of “Id” column.

[pan07]

I Require help in creating Macros for Excel sheet . I have a Excel sheet in which there are many numbers of columns. There is duplication of columns too. I am attaching the Excel for Reference.

I want to create Macro for a particular column name “Id” whose first occurrence should be ‘2’ and after that it must increment by 1.
There must be a validation that before setting the “Id” column value, the previous column (left one attached column) must not empty other don’t set the “Id” column Value and check for it’s next occurrence and same validation.

One More Thing as the column numbers can vary means can increase i.e. there is no fix no of “Id” column. So this setting of value should occurs till the last occurrence of “Id” column.