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...
If you use a pivot table, be warned: Pivot tables use a cache to hold summary data from their source. If you update the source data, you need to remember to Refresh the table (cache) to see accurate results.
But a calendar does not have that limitation, and it need not use complicated formulas. See the attached workbook, and read the notes on the _Info worksheet. Let me know if you have questions.
I think you can try this out just by copying and pasting your bed assignment data (only the Date and Bed columns are needed!) over the sample data on the Assignments worksheet.