View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Badger
 
Posts: n/a
Default How do I populate a worksheet name in a formula using a cell ref.

I would like a worksheet to populate from another worksheet of my choosing by
entering the worksheet name I wish to use in a cell and referencing it in an
"if" formula. I can't seem to find a way to reference cell A1 as a worksheet
name without A1! showing up as the reference. Any ideas?