With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, January 4, 2013
yogi_Create Dynamically Expanding Recurring List From Specified Ranges
user J Gilroy said:(http://productforums.google.com/forum/?zx=ey3zne3xqlhg#!category-topic/docs/spreadsheets/uhPngSPal_I)
Create recurring lists from ranges
I would like to create a dynamic spreadsheet which grows as entries are added to a defined range. For instance, I might have 2 ranges:
I want to create a table like the following:
If I add another person to this list by adding that person to the "Person" range, I want them automatically added 5 times with the days listed next to them. I'm at a loss as to which functions I need to pull this off.