I have a COUNTIFS formula that works great in the cell, it gets data from a different worksheet (Case Detail),
but I want to use the formula in a Form control button on the first worksheet (client report). This is the formula...
=COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16")
This is 1 formula of many that I will put into the Form control button, but if I can get help on how to do this one, maybe I can figure out how to add the rest, so I can run the report by clicking 1 button.
I am new to VBA, so any help, I would be grateful.
but I want to use the formula in a Form control button on the first worksheet (client report). This is the formula...
=COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16")
This is 1 formula of many that I will put into the Form control button, but if I can get help on how to do this one, maybe I can figure out how to add the rest, so I can run the report by clicking 1 button.
I am new to VBA, so any help, I would be grateful.