Forum Discussion
Auto Populate a Table based on values entered in a single cell
Hi J_D_B
In any case you'll need - somewhere in your workbook - something like a Date that indicates when your Raw Data was last updated
Attached is a Get & Transform aka Power Query sample. To play with it:- Update data in 'Raw Data'
- Change Last update date2 ways to see the Summary addition in 'SummaryHisto':
Go to Data (tab) > Refresh All
OR Close the workbook (saving your change) > Re-open it (the query that updates SummaryHisto is configured to auto-refresh when the file opens)Note:
Additions to 'SummaryHisto' only takes place if the Last update date doesn't already exist in SummaryHisto. In other words, you can do as many Data > Refresh All you want nothing will be added to 'SummaryHisto' if Last update date already exists in the History
This is exactly what I need, thank you.
I am struggling to see how you created this doc as I am not seeing any formulas on the SummaryHisto sheet that explains how you managed to get the table to update everytime the date changes (or is this a trade secret lol?)
But this is exactly what I was looking for. Thank you, I really appreciate all your work and help with this.
Kind Regards
J
I am struggling to see how you created this doc as I am not seeing any formulas on the SummaryHisto
There's no Excel formula, it's all done with https://learn.microsoft.com/en-us/power-query/power-query-what-is-power-query. To see (and Edit) the queries:
- Go to Data (tab) > Queries & Connections (the corresponding pane opens on the right)
- Double-click on a query name to Edit it
(Power Query functions doc. is available https://learn.microsoft.com/en-us/powerquery-m/)
Something I forgot to mention is my previous post: if no date is enterred in RawData!Last update, SummaryHisto doesn't update