auto-generate number based on date

[mychi11]

Hi folks,

I was wondering if it is possible to auto generate sequential number based on the date in excel while trying to skip the number based on conditions. For example, I have different process A, B, C. I only want to auto generate number specifically for process A only based on date. I don't know if I have made this sounds too complicated. But yeah. thanks all for your time if you're reading this question.

 

[ranman256]

Put the cursor in the cell that gets the number,run the macro. (Put a shortcut on the immediate toolbar)
Adjust Offset cell that has the codes A,B,C.

Sub makeNum()
If activecell.offset(0,1).value ="A" then activecell.value = format(now(),"yymmddhhnnss")
End sub

 

[mychi11]

Hi ranman, thank you for your prompt response. I am not very good with excel. I don't really know how to go about it. Do you mind to explain the steps in more details please