Can Row and Column Inputs in 2 Var. Data Table be on a separate sh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
When you are in the dialog box asking for reference cells, simply switch to
the other worksheet and point to the cells.
 
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).
 
When I try to reference the other worksheet I get the following error: "Input
cell reference is not valid."
 
My apologies. You're right about the error. Unfortunately, I have no
workaround for you other than what you've described.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
sorting data from one table/range to another table/range 1
Getting Text data using the Data - Subtotal feature 1
Row jumping formula? 8
Conditional SUBTOTAL in XL210 Table 7
Conditional Format with Name Range? 1
how do i create a table in excel 2003? 3

Back
Top