How do I populate a worksheet name in a formula using a cell ref.
lookup the Indirect formula in the funciton wizard. This may do what you want.
"Badger" wrote:
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?
|