Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two worksheets. In worksheet A I have a table where the columns are
the months (0701 - 0712) In worksheet B I have one table which contains formula's with calculations for one month. So I made a dropdownlist with Data-Validation to select the month. What I'm looking for is to automatically change the references to the columns in worksheet A, which are used in the forumulas in the table in worksheet B. So when the month 0702 (Column B) is selected, the formulas should reference to column B. When the month 0703 (Column C) is selected, the formulas should reference to column B. Does anyone know how I can do this? Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automatically show cell references of formulas | Excel Discussion (Misc queries) | |||
how do I change cell references automatically in formulas | Charts and Charting in Excel | |||
how to change column references, while filling down another column | Excel Discussion (Misc queries) | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions |