creating if else statement (combine 2 modules)

niailmar

New member
Joined
Apr 4, 2012
Messages
30
Reaction score
0
Points
0
Hello everyone.


I have 2 modules in 1 workbook (report template). Each of these modules have codes such as below:


1) Personal Claim (PC)


2) Guarantee Letter (GL)


My problem is I want to create only 1 module. Inside this module can have the code both of PC and GL, and need to used IF ELSE code. Can anyone help me how to create IF ELSE statement?


I also attach the example of report template, PC and GL form that I create. Thank you.
 

Attachments

  • 2012-05-28, 1512, Personal Claim Form of Mamat Bin Jaafar.xls
    269.5 KB · Views: 16
  • 2012-05-28, 1513, Guarantee Letter Request of Mamat Bin Jaafar.xls
    122 KB · Views: 15
  • report template.xlsm
    447.7 KB · Views: 15
Back
Top