I have uploaded a sample chart. Link is http://hotfile.com/dl/137078594/7cab2f3/Sample_Chart.xlsx.html
In this chart, you will notice that a Shape has been inserted to highlight the current month which is December. I would like to automate this highlighting part, so that I don’t need to slide...
Please help.
I need a formula in Column D which will provide the Subtotal of Column C depending upon change in Column A and B. Expected formula result is given in Column D.
While you guide me with your formula/procedure, kindly consider that the worksheet is already very large and will grow...