Can I get the vba code for the below formula please?
=IF(A2,UPPER(LEFT(D2,3)&LEFT(C2,3)&TEXT(ROWS(A$2:A2),"0000")),"")
I need to take first three digits/numbers from column D2 & C2 and add number starting from 0001 as it goes down each row it should increase as 0001, 0002, 0003... so forth. Eg...