rbobcat1
Member
Can the below formula be put in VBA?
I use it in a table and sometimes the formula gets accidentally messed up which causes a problem
I also have to copy & paste the A? cell to hard code the number left after the date in C5 is entered.
I have the formula in A5 and as lines are added it changes by the date entered in C5 and increments by 1
=TEXT(C5,"YYYYMMDD")&TEXT(COUNTIFS(C$5:C5,">="&INT(C5),C$5:C5,"<"&INT(C5)+1),"-000")
I use it in a table and sometimes the formula gets accidentally messed up which causes a problem
I also have to copy & paste the A? cell to hard code the number left after the date in C5 is entered.
I have the formula in A5 and as lines are added it changes by the date entered in C5 and increments by 1
=TEXT(C5,"YYYYMMDD")&TEXT(COUNTIFS(C$5:C5,">="&INT(C5),C$5:C5,"<"&INT(C5)+1),"-000")