I have a spreadsheet with Start date, (Column C) and
Service, Column E)... What I want to do is, on another
tab, have a button that states total... When the button is
clicked, a input box comes up with a drop down list of
years, 2000, 2001, 2002, 2003... The user hits what year
the they want to see, and a message box pops up with the
total... The code would have to search through Column C
for the requested year, and add when the criteria is met
add Column E... I'm assumming that I would need two
ranges, Start Range and Service Range??

Thanks in Advance
Kevin...