View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric[_20_] Eric[_20_] is offline
external usenet poster
 
Posts: 31
Default Variable sheet name in formula

Hello,

I dont know if this is possible, but I am trying to build a formula which
contains the name of a sheet that will change every day.
In fact, I would like a cell to contain the name of the sheet and then
reference the content of that cell in my formula.

Ex: sheet2.A3 would contain the text "Sheet2"
my formula would look like = sheet2.A3!B4*C45........., where sheet2.A3!B4
would be cell B4 of sheet2.


Thank you.

Eric.