Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Referencing
I have Worksheets("Data") and worksheets named for each year ONLY the
current year and previous years are available, ie Worksheets("2011") will not exist until it is 2011. Worksheets("Data") is a summary worksheet. It pulls totals and/or averages from each year worksheet. Since future year worksheets do not exist until that year arrives, I have formulas on the Data worksheet that check to see if that year is here. If not, then "". Hence, when a new year worksheet is created, it will also place that year, ie 2010, as the column header, say in cell E8 of Worksheets("Data"). The cells in column E, below E8 will reference a particular cell on the 2010 worksheet. My question is this: What is the formula that will use the value in E8, in this case 2010, to reference E16 on Worksheets("2010")? F8 will eventually be 2011, etc. and the cells below each will pull data from the appropriate worksheet based on the value (year) in E8, F8, G8....AH8. Example: Worksheets("Data") E8 = 2010 Instead of formula in E16 being: =IF(E8 = "","",2010!E16) I want the 2010 portion of the formula to reference E8 to pull the value. Sorry if wordy, but wanted to make clear as possible. Thanks for your help, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a cell | Excel Discussion (Misc queries) | |||
Cell Referencing | Excel Worksheet Functions | |||
Cell Referencing | Excel Discussion (Misc queries) | |||
Referencing Cell Next To Today's Date Cell | Excel Discussion (Misc queries) | |||
referencing a name from a cell value | Excel Discussion (Misc queries) |