On one worksheet, I am trying to reference cell A2 in table1 in cell A20 on
table 2 . I want to fill the table 2 down to cell A29, however I am
referencing data that is in just one row table 1, i.e. the data is in cells
A1, B1, C1, D1, etc on to J1. I don't want to just copy and paste/transpose
the data from table 1 to table 2 because I want to maintain the references. I
could just take table 1 and transpose it, than create the references, but
prefer not to. Any ideas? Thanks