Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Referencing between multiple worksheets
I need some help on a problem I have. In excel 2007 I want to make cell A1
equal the value of cell B1, which is on a different worksheet. However, I want cell A1 to change which cell it references based on what month it is. For example, if it is January, I want cell A1 to reference cell B. However, if it is February I want it to reference cell B2. I already have a cell, C1, where I put in the number corresponding with what month it is that I reference for other formulas. Any ideas? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing cells in multiple worksheets | Excel Discussion (Misc queries) | |||
Excel 2003 Referencing multiple worksheets | Excel Discussion (Misc queries) | |||
Macro referencing multiple worksheets | Excel Discussion (Misc queries) | |||
Formula Referencing data on multiple worksheets | Excel Worksheet Functions | |||
Summary worksheet referencing multiple worksheets | Excel Worksheet Functions |