Update a table add today's data

[hedgie]

I have a table which is simply a column for Date and one for the current Date's revenue of the day. The revenue comes fromm a different sheet in the workbook which is replaced each day. Currently we basically cut and paste that row as a value to make it static and then the next day, the row below uses the new data from the updated sheet. Is there a way to automate this, so that when new data is entered into the data sheet, the table will keep all the older data?

 

[DRSteele]

Yes, there is. You can use Power Query to update your report from the source data. Or, you can use dynamic array formulas to extract the data from the source data, as long as you don't require to be the report table yo be an official Excel Table.