accessing variable sheet ranges within Google spreadsheet?
- by Daniel Harvey
I've been trying to keep this little project entirely within Google docs, but I may have hit a wall. The spreadsheet is being used as a way for multiple users to record individual events with a Template they duplicate. I want to be able to compile a list of names of those attended onto a "report" sheet from all of the unique sheets, which should be after a certain sheet index [3] to [infinite].
Is this sort of variable sheet range possible in Google spreadsheets or do I need to go to the API to get this accomplished?