need help with macro modification please

E

excelguru

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
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need small help with excel macro please 3
Need Help with Macro Security 1
Menu Macro Not Executing - Need Help 1
Couple subs need help with 2
Programatically sort and highlight 1
Need help with a complicated macro (code change) 2
Custom Macro for pulling information into one sheet 0
Sorting CSV Data By Date 8

Top