Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

This is a bit of a general question.

I am creating a tournament scheduler in Excel and I was wondering if I could do something a bit more advanced than just spreadsheet sharing for teams to update their scores.

My thinking is this: Create a macro with specific username and password for each team and they can then only update their own scores, and have the opposing team be able to approve the scores to validate them. I don't think that coding this would be a problem but my issue here is that I do not know where I can upload this for everybody in the tournament can have access to it as we do not have a shared file server. How can I have the shared spreadsheet available to everybody freely?

share|improve this question
1  
Prepare your Excel sheet offline and share it online with Office 365 (newer office versions only) or upload the spreadhseet to Google Docs (other formula syntax needed) and grant access to different gmail accounts –  nixda Aug 8 '13 at 11:17

1 Answer 1

You could use Dropbox or something similar, but then you'd have the problem of more than one person accessing it simultaneously, so you'd need to coordinate somehow.

Depending on the complexity of the macro, why not use a Google Drive Spreadsheet? They've gotten a lot more advanced in recent years...

You'll need to write an Apps Script which will function as a macro and can also interact with other Google documents I believe. There's a good info page here: Extend Google Docs, Sheets, and Forms with Apps Script - Drive Help

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.