Calcualting values from different worksheets

[creyn]

I am trying to calculate values from two different worksheets onto one sheet. Below is the code I am trying to use. What am I doing wrong?


Range("P2:P2515").AutoFilter field:=16, Criteria1:="=SUBTOTAL(9,P2:P2515)" - Worksheets("ITBM Summary").Range("C26").Value

 

[JoeMo]

Try:

Criteria1:=[SUBTOTAL(9,P2:P2515)] - Worksheets("ITBM Summary").Range("C26").Value

 

[creyn]

I tried to run this: Criteria1:=[SUBTOTAL(9,P2:P2515)] - Worksheets("ITBM Summary").Range("C26").Value, but it did not work. Can you suggest any other solutions?


Range("P2:P2515").AutoFilter field:=16, Criteria1:="=SUBTOTAL(9,P2:P2515)" - Worksheets("ITBM Summary").Range("C26").Value

 

[JoeMo]

I tried to run this: Criteria1:=[SUBTOTAL(9,P2:P2515)] - Worksheets("ITBM Summary").Range("C26").Value, but it did not work. Can you suggest any other solutions?


Range("P2:P2515").AutoFilter field:=16, Criteria1:="=SUBTOTAL(9,P2:P2515)" - Worksheets("ITBM Summary").Range("C26").Value

"it did not work" is not a helpful description for diagnosing the problem. What exactly happened when you tried to run the code? If you got a run time error, what was the error and what line was highlighted when you got it?

 

[creyn]

I am trying to calculate values from two different worksheets onto one sheet. Below is the code I am trying to use. What am I doing wrong?


Range("P2:P2515").AutoFilter field:=16, Criteria1:=[SUBTOTAL(9,P2:P2515)] - Worksheets("ITBM Summary").Range("C26").Value

 

[creyn]

I am using this code now: Private Sub CTI()

Range("B1").AutoFilter field:=2, Criteria1:="1001 - North America"
Range("J2").AutoFilter field:=10, Criteria1:="CTI - Non Consumable"
Range("T2").AutoFilter field:=20, Criteria1:="-"
Range("P2517").AutoFilter field:=16, Criteria1:=Worksheets("ITBM Detail").Range("P2516").Value + Worksheets("Exp Current Mo").Range("E26").Value

End Sub


I do not receive an error. The worksheet removes all the values and places a 0("P2517") in the field. Can you help me with what I am doing wrong?