🔒 Closed Need Help sa Code sa Excel

Status
Not open for further replies.

mhieru

Grasshopper
1614501749138.png


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..
 
Status
Not open for further replies.

About this Thread

  • 2
    Replies
  • 435
    Views
  • 2
    Participants
Last reply from:
mhieru

Online now

Members online
992
Guests online
1,257
Total visitors
2,249

Forum statistics

Threads
2,277,039
Posts
28,973,868
Members
1,229,695
Latest member
Smile2742
Back
Top