Sunday, March 19, 2017

yogi_Create Table Of Students With Incomplete Assignments (marked *)

Google Spreadsheet   Post  #2132
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-19-2017
question by CHMS:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/6f5wCUNPNYc;context-place=forum/docs
Macro or formula to extract info from multiple tabs based on criteria into new tab?
Hi,
I work with a team of teachers and we use Google Sheets as our shared gradebook. We have multiple tabs (one for each class) where we record our grades. Not all of our students are in each class, so each tab has column A where the students names are listed and row 1 where the assignments are listed. We would like to use a macro or formula to look through all of the tabs for "*", which represents an incomplete assignment and return the student's name, the assignment title, and the tab (class) name to a new tab. This would allow us to have an always up-to-date list of work that students are behind in.

I've read about a lot of ideas that seem to work for only part of the problem. We would really appreciate help on this. 

Thanks,
Carla