Microsoft Excel

Search from multiple condition

IFERROR(INDEX(ArrayResult,MATCH(1,(ArrayCondition1=ValueCondition1)*(ArrayCondition2=ValueCondition2)*(ArrayCondition3=ValueCondition3),0)),"No Match")

IFERROR(INDEX(D3:D10,MATCH(1,(B3:B10=D12)*(C3:C10=D13),0)),"No Match")

=IFERROR(INDEX(Data!D:D,MATCH(1,(Data!B1:B1000=GH10)*(Data!E1:E1000=GH28)*(Data!F1:F1000=GH19),0)),"")


Error using this formula
1. excel ran out of resources while attempting to calculate one or more formula
Solution :
Make array limitation.  
Example: array D:D change to D1:D1000

Macros Print Activesheet

 

Macros Print Activesheet

Private Sub ButtonPrintEpson_Click()
    
    Application.ScreenUpdating = False
    ActiveSheet.PrintOut
    Application.ScreenUpdating = True
      
End Sub 

Macros Print To PDF

VBA Macros Print To PDF

 

 

Private Sub ButtonPrint_Click()
    
    Application.ScreenUpdating = False
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
    Filename:="C:\Users\~User~\Documents\norazizah\KalendarPDF.pdf", _
    OpenAfterPublish:=False
    Application.ScreenUpdating = True
      
End Sub