change formula references from one tab to another
 

I have a series of formulas in cells and drop downs linked to another tab in
my worksheet. What I want to do is make a series of tabs that has slightly
different info in them. I want to then give a person the option to pick what
tab the furmula will read from. I have a coworker that brought up "radio
buttons" but I cant find anything. Please help.

change formula references from one tab to another
 

DV list of sheetnames in Sheet1 C1

In D1 enter =INDIRECT(C1 & "!A1")

Will return contents of A1 from whichever sheetname is selected in C1


Gord Dibben MS Excel MVP

On Mon, 3 Nov 2008 09:41:02 -0800,
wrote:

I have a series of formulas in cells and drop downs linked to another tab in
my worksheet. What I want to do is make a series of tabs that has slightly
different info in them. I want to then give a person the option to pick what
tab the furmula will read from. I have a coworker that brought up "radio
buttons" but I cant find anything. Please help.