| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to update/change cell references in a formula | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| Formula Link References Change to Startup Directory | Links and Linking in Excel | |||
| formula references change when data entry sheet is modified | Excel Worksheet Functions | |||
| How do I change column references when filling down a formula | Excel Discussion (Misc queries) | |||
Linear Mode
