if I use the following code I end up with what ever row the formula is in from the correct table, i want to specify the row #
That works fine if I do not want to manipulate, or populate that data in a different order.
that formula will use the row # the formula is in and pull from the same row number as the table + column.
If the formula resides on row 25 on a different worksheet, i can ONLY have the value from row 25 of table + column. That is not what I want. I might need the data from table + column in row 25 to display on row 10 on some other worksheet.
How can I do that? edit to add: Without using standard reference. My columns are known to change location (order if you will) so I do not want to use normal identifiers for the formulas/linking of data.
Code:
=tTable1[@Group]
That works fine if I do not want to manipulate, or populate that data in a different order.
that formula will use the row # the formula is in and pull from the same row number as the table + column.
If the formula resides on row 25 on a different worksheet, i can ONLY have the value from row 25 of table + column. That is not what I want. I might need the data from table + column in row 25 to display on row 10 on some other worksheet.
How can I do that? edit to add: Without using standard reference. My columns are known to change location (order if you will) so I do not want to use normal identifiers for the formulas/linking of data.
Last edited: