Hi guys,
my first post and I'm very new to Excel. please help.
here's what I want to do;
from my excel sheet, certain dates have values and I want to add them up and show them on calendar when I click on that date.
I have the calendar added already but couldn't find a way to do that..
for example;
a1-10/20/2010 a2-1000
b1-10/19/2010 b2-2000
c1-10/20/2010 b3-1500
so when I click on 10/20 from the calendar, I would like an output of 2500.
is this something feasible?
thanks in advance