Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use varaible for worsheet name in a formule
Hi,
In a workbook, I have several worksheet with some figures related to a specific year (one worksheet by year). I have a worksheet to perform some calculation and so I use formulas like this: =YE04!B5-YE01!B5 where YE04 and YE01 are worsheet names. I want to use variable to reference worsheet name. Variables will be two cells in a separate worksheet where I put worsheet names to use. 1rst variable, called "start",will be cell A3 in worsheet "Reference" and 2nd varaible, called "end", will be cell B3 in worsheet "Reference". I want to be able to write formula like =start!B5-end!B5. Is it possible? if yes how to do? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink varaible substitution - How To | Excel Worksheet Functions | |||
Disappearance of assigned value of varaible when working with form | Excel Programming | |||
need help with a formule | Excel Programming | |||
formule | Excel Programming | |||
Passing a named varaible to Excel's Autofilter | Excel Programming |