Pamella
09-16-2019, 08:04 AM
21,26,27,32,33 , ""AC"",""BR"",""DX"",""GE"" instead of hardcoding like this, how can I refer to cell references- need to create a separate Sheet where I can add these so the user can add/remove as they wish.
There are multiple forumulas.
I have this in VBA code:
ActiveCell.FormulaR1C1 = "=SUM(SUMIF('15-Aug-19'!C[-5], {21,26,27,32,33,""AC"",""BR"",""DX"",""GE""}, '13-Aug-19'!C[-3] ))"
There are multiple forumulas.
I have this in VBA code:
ActiveCell.FormulaR1C1 = "=SUM(SUMIF('15-Aug-19'!C[-5], {21,26,27,32,33,""AC"",""BR"",""DX"",""GE""}, '13-Aug-19'!C[-3] ))"