change formula references from one tab to another

  • Thread starter Thread starter aspencer
  • Start date Start date
A

aspencer

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.
 
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
 
Back
Top