Need VBA Code for Delivery Challan

[witsonjoyet]

Hai Experts,

Please help me to get a code for my problem. Daily i have to raise 600 prints for Delivery Challans. Mainly it has been segregated as the following :

--->4 types of meals : 1)Breakfast ; 2)Lunch ; 3)Dinner ; 4)Hi_Tea
--->for each session we have different flights ( as i am working in Airport, i have to give delivery challans for in-flight services).
--->i have a fixed templates for each type of meals and for every 1st,3rd weeks we have one type of rotation and for 2nd and 4th weeks we have second rotation.
--->in each rotation from Monday to Sunday, Standard meal will be served ( Everyday meal will change but its under that rotation meal only)

Problem is i have created a dash board , now when i select Breakfast and a flight number , i want to print that delivery challan ,
Is there any possibility to do it in VBA?
For better understanding i am attaching my dummy file.

Thanks n Regards
Witson

[anandagrawal444]

Can you please post one sample DC with complete data to understand the problem better

[anandagrawal444]

The below code for printing one DC. If this works then code for balance two actions can be created. Please check this and confirm.

Please Login or Register  to view this content.

[witsonjoyet]

Thanks Mr. Anand,

Please find the attached original DCs format. please help me to get the codes.

Regards
Witson