VBA- Auto Increment Number each time data was introduced to a new row

[hotseetotsee]

Hello! I am new to excel VBA and I need a bit of help.

I have a table that have columns such as ID, Name, Duration and etc respectively.

Okay, so the requirements stated requires me to:

• Make the ID column as non-editable, which I have done by locking the ID column ONLY https://www.dropbox.com/s/z066x75x78w852u/VBA cells locked.png?dl=0
• Next, the ID column for the first row (which is A6) need to self-initiate ID as 1 when I write data into Name, Duration and other columns of the row. This is the part where I lost for solutions. https://www.dropbox.com/s/ncaajqex8yweydd/VBA self-initiate ID in IDCells.png?dl=0

Is this possible? If it is, please help! Much thanks

 

[Michael M]

homework / assignment ???

 

[hotseetotsee]

homework / assignment ???

It’s an assignment

 

[Michael M]

In that case we can't / won't do your work for you !!.....mainly 'cause we don't get the credits when you pass !
However, you probably need to look at
1. Why use VBA, when a formula will do it ?
2. An IF statement in cell A6 to see if there is anything in B6
3. An IF/AND statement in cell A7 to see if there is anything in B7 AND anything in A6

If you must have VBA, you will need to post what code you have done already.... and what does / doesn't work for you !!