We download a Profit and loss report from Xero into excel. We then need to run calculations on each row that is imported. Datadear automatically creates a table with the imported data.
My question is how can i setup a duplicate table (of the datadear import) in another excel tab so i can run calcs on each datadear row.
The reason I now need a duplicate table is that in a recent Datadear update all helper columns are now deleted when refreshing a datadear table.
The "Linked table would need to expand dynamically as the datadear table expands without th user needing to drag the formulas down.
Any help would be appreciated.