View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
slm slm is offline
external usenet poster
 
Posts: 3
Default 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