Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate according to Drop Down control list value
Hi all, In Range("B7:M7") I have months headings like "APR 08 , MAY
08 …. till MAR 09" and two rows below from these headings in Range("B10:M22") I have amounts. I also have two drop down controls on top of the Sheet. Each of those also got months in drop down list like "APR 08 ..... MAR 09". One cell to right of those drop down controls i gave heading like to first one i put "FROM" and to second one i put "TO". "FROM" drop down control result cell is Range("B3") and "TO" drop down control result cell is Range("D5"). I want macro on a button that when i select any month in drop down list of those controls like if i select "APR08" in "FROM" drop down control list and "AUG 08" in "TO" drop down control list then macro should check those months and the months between them in Range("B7:M7") headings and SUM the amounts coming in those months columns in Range("B10:M22") and put result in Range("O10:O22"). I have uploded my excel file in here (http://www.savefile.com/files/1872510). Please see my file for more clear understanding. I'll really appricate any help from any friend. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to control drop down list width | Excel Worksheet Functions | |||
how to calculate depend on drop-down list value? | Excel Discussion (Misc queries) | |||
Limit data entered to list (drop-down control) | Excel Programming | |||
Control Display of Drop Down List in Validation | Excel Worksheet Functions | |||
Combo box control Drop down list moving | Excel Programming |