i have two sheets one is "input" and the other is "master" Sheet input has three columns WEEK,working hrs, and worker name, sheet master has all unique worker names in column A, and W1,W2......W13 in column b1,c1,d1...and so on
i want a sum ifs loop so that it can give result for workers working hrs in my masters table in their respective weeks(w1 to w13).
i m using a sum ifs formula for this :
Formula = "=SUMIFS(Input!C32,Input!C37,Master!C1,Input!C31,Master!B1)"
Any suggestions how to loop it in VBA
Please help....