| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I referance a data valuation cell from another worksheet
I have a problem where I want to referance a cell that is using data
valuation to get one of 4 results and bring the results to another worksheet. I've tried to link the worksheets but I don't get the information. The worksheet 1 cell d19 refers to one of 4 inputs range $g$1:$g$4, I want to be able to pull that information over to another worksheet called calculations, The same cell as worksheet 1 (D19) is the same as the calculations worksheet (D19). Any help would be greatly appreciated Ken |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I referance a data valuation cell from another worksheet
Ken this isn't the most dynamic solution but try this:
Worksheet 1 in any cell (lets say C19) enter =D19 worksheet Calculations in cell D19 enter =C19 I expect somebody else will come up with a better solution "Ken C" wrote: I have a problem where I want to referance a cell that is using data valuation to get one of 4 results and bring the results to another worksheet. I've tried to link the worksheets but I don't get the information. The worksheet 1 cell d19 refers to one of 4 inputs range $g$1:$g$4, I want to be able to pull that information over to another worksheet called calculations, The same cell as worksheet 1 (D19) is the same as the calculations worksheet (D19). Any help would be greatly appreciated Ken |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I referance a data valuation cell from another workshee
Whoops! sorry
Should be: worksheet Calculations in cell D19 enter ='worksheet 1'!C19 "Ron@Buy" wrote: Ken this isn't the most dynamic solution but try this: Worksheet 1 in any cell (lets say C19) enter =D19 worksheet Calculations in cell D19 enter =C19 I expect somebody else will come up with a better solution "Ken C" wrote: I have a problem where I want to referance a cell that is using data valuation to get one of 4 results and bring the results to another worksheet. I've tried to link the worksheets but I don't get the information. The worksheet 1 cell d19 refers to one of 4 inputs range $g$1:$g$4, I want to be able to pull that information over to another worksheet called calculations, The same cell as worksheet 1 (D19) is the same as the calculations worksheet (D19). Any help would be greatly appreciated Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to referance data from or to a closed workbook from | New Users to Excel | |||
| how do i referance an adjacent cell from a search? | Excel Discussion (Misc queries) | |||
| copy a same referance from diffrent worksheet on another file | Excel Worksheet Functions | |||
| Formula that referance a Cell | Excel Discussion (Misc queries) | |||
| Cell referance for formula | Excel Worksheet Functions | |||
![Ken C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
