Sunday, June 10, 2012

yogi_Setup Individual Sheets Named After The Persons Where Only Data For Sheet Named After The Person Is Pulled From Sheet1

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #587    Jun 10, 2012     www.energyefficientbuild.com.

user Gaming said:

Here's a spreadsheet demo


Now pay attention.
Tim, Paul and Jon are now going to go over the results. They find their name in the filter and see the results they have to go over. Now when they are doing this all at the same time, the filter always switches. So if Tim is going over the applications, and then Jon comes and selects his name for the results, it changes and Tim has to then change back to show only his name, but then Jim has to do it also, so it's kinda obvious that this isn't very helpful to have it on 1 sheet. However, I would like to have the results on multiple sheets, so they can all have specific filters for every sheets. I'm asking if there is a possibility too show live results on every sheet.
Thanks
------------------------------------------------------------------
in the following solution to the problem ... I have created a separate sheet for each of Tim, Jon, and Paul ... well without much further ado, let us have the solution do the talking