Forum Discussion
Trying to pull specific data from spread sheet to a calendar
Hello, I'm trying to figure out an easier way to populate specific data totals from a spread sheet to a calendar. i have made a spread sheet similar to what we use (excluding patient data of course...
Hi sneakysloth
I would recommend you follow the easy route suggested by Riny_van_Eekelen
A calendar sounds doable with Power Query (+ Excel 2021 or 365):
If no Period is selected in the drop-down list current Month + Year is used by the query
(not intensively tested but appears to work decently...)