Thanks for your help.I don't know anything about macros.Please 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 DE

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

--
excelgur
-----------------------------------------------------------------------
excelguru's Profile: http://www.excelforum.com/member.php...nfo&userid=882
View this thread: http://www.excelforum.com/showthread.php?threadid=46763