If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can Row and Column Inputs in 2 Var. Data Table be on a separate sh
I have created a two variable data table that I would like to reference data
from a separate worksheet (i.e., the Row and Column Inputs would reference cells on a separate worksheet). How can I accomplish this? |
#2
|
|||
|
|||
When you are in the dialog box asking for reference cells, simply switch to
the other worksheet and point to the cells. "RED" wrote: I have created a two variable data table that I would like to reference data from a separate worksheet (i.e., the Row and Column Inputs would reference cells on a separate worksheet). How can I accomplish this? |
#3
|
|||
|
|||
I tried that, but it did not work. The only thing that seemed to work was to
hardcode the inputs into the Row and Column Input cells on the worksheet containing the data table and then refer the other worksheet to these cells (I want to do the reverse). "Duke Carey" wrote: When you are in the dialog box asking for reference cells, simply switch to the other worksheet and point to the cells. "RED" wrote: I have created a two variable data table that I would like to reference data from a separate worksheet (i.e., the Row and Column Inputs would reference cells on a separate worksheet). How can I accomplish this? |
#4
|
|||
|
|||
When I try to reference the other worksheet I get the following error: "Input
cell reference is not valid." "RED" wrote: I tried that, but it did not work. The only thing that seemed to work was to hardcode the inputs into the Row and Column Input cells on the worksheet containing the data table and then refer the other worksheet to these cells (I want to do the reverse). "Duke Carey" wrote: When you are in the dialog box asking for reference cells, simply switch to the other worksheet and point to the cells. "RED" wrote: I have created a two variable data table that I would like to reference data from a separate worksheet (i.e., the Row and Column Inputs would reference cells on a separate worksheet). How can I accomplish this? |
#5
|
|||
|
|||
My apologies. You're right about the error. Unfortunately, I have no
workaround for you other than what you've described. "RED" wrote: I tried that, but it did not work. The only thing that seemed to work was to hardcode the inputs into the Row and Column Input cells on the worksheet containing the data table and then refer the other worksheet to these cells (I want to do the reverse). "Duke Carey" wrote: When you are in the dialog box asking for reference cells, simply switch to the other worksheet and point to the cells. "RED" wrote: I have created a two variable data table that I would like to reference data from a separate worksheet (i.e., the Row and Column Inputs would reference cells on a separate worksheet). How can I accomplish this? |
Thread Tools | |
Display Modes | |
|
|