May have bitten off too much to sort

[hyancey]

I am trying to accomplish something that is feeling rather like a lost cause at the moment. I may be asking too much of the application. Here is what I am doing...

Built a Google Form that will populate a Google Spreadsheet (have same functionality as excel sheets and will build in Excel then upload). I need the sheet that contains the responses to autosort the entries to other sheets in the workbook based on the name of the person who submitted the data (name will be listed consistently in Column B, Sheet1) so that I will ultimately have a workbook with 8 tabs that are each named after the specific data entry person referenced in Column B, Sheet1. I want the 2nd, 3rd, etc sheet to reflect only the entries put in by that specific person so we can manipulate the data to see time used on specific projects.

I have been staring at the formulas and data too long and it just doesn't make sense how to accomplish this anymore. Help!

 

[RedBeard]

If you can automate the name using Application.UserName somehow, maybe?

Not sure whether Google Spreadsheet would accept that though.

 

[Smitty]

Welcome to the Board!

If you're gathering input from people, why not use the Survey tool in the Excel web app? It's free and you can host it through OneDrive. It feeds to a hidden Excel workbook, and you can then summarize the data with Pivot Tables. If you create a master pivot table and put user name in the Filter field, then you can use the Show Report Filter Pages option, which will create a new Pivot Table sheet for each name in the list.

HTH

 

[RedBeard]

That's a fantastic tool, thanks for making me aware of it.

Welcome to the Board!

If you're gathering input from people, why not use the Survey tool in the Excel web app? It's free and you can host it through OneDrive. It feeds to a hidden Excel workbook, and you can then summarize the data with Pivot Tables. If you create a master pivot table and put user name in the Filter field, then you can use the Show Report Filter Pages option, which will create a new Pivot Table sheet for each name in the list.

HTH