View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Huggy Huggy is offline
external usenet poster
 
Posts: 14
Default reference other worksheets via variable names

Is it possible to reference another worksheet by entering the name of that
worksheet in an input cell within the current worksheet and referencing this
cell within a function in the current worksheet.

example: current sheet name "Convert" cell C11 required to be = to cell H5
on another worksheet named either "word" or "report". The typical function
would be "=Word!H5" or "=Report!H5"

How do I make the "Word!" part of the above function a variable?