I am trying to make a calendar that allows anyone who clicks on a single day to get display with a list of data stored (4-5 different data types) for that day. What is the most effective way to store and retrieve great amounts of data like this? I know I could use vba to create a set of background databases (one for each of the stored data types), but this seems cumbersome. Is there anyway to natively store more than one data value in a cell(in the background)?
Example:
January 1st
Data Stored
-Person 1
-Person 2
-Location
-Task
Any help would be appreciated.
Example:
January 1st
Data Stored
-Person 1
-Person 2
-Location
-Task
Any help would be appreciated.