Need Help sa Code sa Excel

[mhieru]

Main Food Code is "10"

• C5 meron Dropdown List for selection of Category (sa sample Beverage selected which Category Code nya is "1")
• C7 meron Dropdown List for selection of Sub Category (sa sample Energy Drink selected which Sub Category Code nya is "22")

as it shown sa E3 (10122) Which Main Food Code is 10, Category Code is 1 and Sub Category code is 22. (automatically lalabas ung code) ok na to
main question here is F3 (Automatically maggenerate ng code which is from the last record nung under ng code "10122" tapos mag add sya ng isa from the last number "000003" as it shown sa list..

Then once ok na lahat Once na click ung Add New Item Button (insert nya ung New Item Under sa code na "10122-000004" corresponding sa other data file na nkatype sa (c5,c7, e3 at f3 (pagsasamahin to make "10122-000004"), f5 and f7
then may magprompt na message kung i-add ung code na "10122-000004" or hindi... pag yes (Clear ung value nung c5,c7,f3,f5 and f7) tapos magadd sa list below..

 

[xpeke12]

Para sa alin to paps?

 

[mhieru]

ok n boss,, gumamit n lng me macro