Started By
Message

re: Excel tips: How to populate cells after locking other cells

Posted on 9/17/14 at 4:50 pm to
Posted by finchmeister08
Member since Mar 2011
35830 posts
Posted on 9/17/14 at 4:50 pm to
sorry, i was talking about the google docs method.

eta:
quote:

I'm a little unsure what your end goal is

i want everybody to have access to the spreadsheet via a server here at work. however, i don't want them seeing other peoples picks until after they inputted theirs. the reason i want this is because copying/pasting is a pain.

i wanted to use the access method cause it seemed simple. but i haven't used access since college and it was like reading greek.
This post was edited on 9/17/14 at 4:55 pm
Posted by CubsFanBudMan
Member since Jul 2008
5105 posts
Posted on 9/17/14 at 4:56 pm to
quote:

sorry, i was talking about the google docs method.


The Google Docs method would allow you to create a form each week where each person would enter their name, and their picks. When the user submits the form, Google puts the data from that form into a spreadsheet form. You could then share that spreadsheet with everyone with read only access.

I'm not sure how you're doing the scoring (manually or with formulas in excel), but then you could download the spreadsheet as an excel file to do what you needed for scoring.

first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram