excelmacro
Board Regular
- Joined
- Apr 8, 2002
- Messages
- 50
I have an array
=SUM((CostCenter=$A$3)*(Month=F$4)*(Prime=$A$7)*Cost)/1000
Where:
Cost =Monthly_Actuals!$F$2:$F$20000
CostCenter =Monthly_Actuals!$A$2:$A$20000
Month =Monthly_Actuals!$C$2:$C$20000
Prime =Monthly_Actuals!$D$2:$D$20000
I was just wondering if I could instead of refer to cells such as $A$3 (CostCenter=$A$3) have the referance be to a user inputbox and have the user select this information.
=SUM((CostCenter=$A$3)*(Month=F$4)*(Prime=$A$7)*Cost)/1000
Where:
Cost =Monthly_Actuals!$F$2:$F$20000
CostCenter =Monthly_Actuals!$A$2:$A$20000
Month =Monthly_Actuals!$C$2:$C$20000
Prime =Monthly_Actuals!$D$2:$D$20000
I was just wondering if I could instead of refer to cells such as $A$3 (CostCenter=$A$3) have the referance be to a user inputbox and have the user select this information.