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...
sneakysloth Consider using a pivot table to skip the use of potentially complicated formulas. The attached file contains a small example of what's possible. Note that the data table is formatted as a structured Excel table and that there are no empty rows separating the dates.
Then the pivot table summarizes the data by day and bed type. Exactly what you need but not in a typical (paper) calendar format.
Riny_van_Eekelen this is perfect, i actually haven't used pivot table before so this was a cool tool I'm going to have to experiment with more in other applications. Thank you!