pull certain data from google docs form-produced spreadsheet to other docs
Ok, so I'll try to explain this as simply as possible:
I have a Google Form that dumps data into a Google Spreadsheet (let's call it MASTER). Each row, beginning with a timestamp in column A, has 11 data/columns, A-K.
I need to make individual spreadsheets with different visability options. These should be populated with only some of the data from MASTER. To give what might be helpful context, 4 of the columns in MASTER will each contain one of thirty names. The people with these names need to know that they have been selected as one of the four, and when they are selected, they need to know (almost) the rest of the data on the row in which they are selected.
Let's use example SMITH, an individual spreadsheet fed from MASTER. If "SMITH" appears on any row in columns F through I, SMITH needs to be populated with the data from A-E and J-K on that row but cannot be populated with F-I.
Note: Each individual sheet (e.g. SMITH) needs to update dynamically as MASTER is filled with more data from the form.
Thanks for your help.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Jakub in forum Excel General
Last Post: 02-13-2012, 06:35 PM
By redcrystal in forum Excel General
Last Post: 12-15-2011, 11:58 PM
By ianh in forum The Water Cooler
Last Post: 06-11-2011, 02:11 PM
By Alabaster in forum Excel General
Last Post: 01-13-2011, 01:48 PM
By Shashonie77 in forum Excel General
Last Post: 11-10-2008, 05:37 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1