Hello,
I'm creating a data table in Excel 2007. Is it possible to set the row input cell or the column input cell to a cell that is on a different tab of the same workbook? I get a "Input cell reference not valid" error when I try to do so.
Does anyone have a work-around?
Thanks
Ben
I'm creating a data table in Excel 2007. Is it possible to set the row input cell or the column input cell to a cell that is on a different tab of the same workbook? I get a "Input cell reference not valid" error when I try to do so.
Does anyone have a work-around?
Thanks
Ben