Hi.
This Macro works well when i run it but i am trying to run it continuously with out pressing macro button. I tries to use following code but it doesnt update itself
where its getting data from column L & N and giving consolidated result in AM16
thanks guys
This Macro works well when i run it but i am trying to run it continuously with out pressing macro button. I tries to use following code but it doesnt update itself
Code:
Private Sub Consolidate()
Worksheets("Claims").Range("AM16").Consolidate Sources:= _
"Claims!R6C12:R10000C14" _
, Function:=xlSum, TopRow:=False, LeftColumn:=True, CreateLinks:=False
End Sub
where its getting data from column L & N and giving consolidated result in AM16
thanks guys
Last edited by a moderator: