Need small help with excel macro please

[excelguru]

Thanks for your help

Please run step_one
run step_two .

1.) I need to change macro step two, so that value of cell
(7,AB) will be = total of march + total of june
+ total of july.this was because march was highlighted in yellow

2.) If january month was highlighted in yellow then value of cell
(7,AB) will be = total of JAN + total of FEB+....
+ total of DEC

3.) if July month was highlighted in yellow then value of cell
(7,AB) will be =total of JULY + total of AUG+....total of DEC

4.) if Oct month was highlighted in yellow then value of cell
(7,AB) will be =total of OCT + total of NOV + total of DEC


+-------------------------------------------------------------------+
|Filename: test_excel_file.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3818 |
+-------------------------------------------------------------------+

 

[David Adamson]

Look at the 'select case' statement

 

[excelguru]

I don't know hot wo use the "select case" statement.This macro was given
to me by somebody.actually i am not very familier with macros..

Please help

 

[David Adamson]

Look at the help files