#1
|
|||
|
|||
Drop down list to overlay column of cells with different formulae
Hi, I have a table with several metrics in rows, and monthly data going across the table horizontally with a totals/averages column at the end.
Because the monthly data will eventually stretch over several years (some of which will be hidden when not in use) I wish to include a drop down selection list on the totals/averages column to allow the user to select which year of data they wish to calculate totals of. Upon selection of the year, I would like each row of totals to include the same formulae, but for a different range of data. Furthermore, I was wondering if it would be possible to include a calculation within a conditional format? I want a value to be highlighted if the % based on two other cells is less than a certain amount. I've tried googling for a solution to these queries with little success so any advice would be appreciated. Regards, Tom |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data | Faldinio | Word VBA | 7 | 10-19-2014 06:03 AM |
Return Sum value of one column from cells not blank in another column | zulugandalf | Excel | 3 | 08-14-2014 03:37 AM |
How to "hard link" two adjacent cells to a data validation drop down list? | Geza59 | Excel | 10 | 10-19-2012 11:56 AM |