I would like to know if something is possible and where to start.
Each day, my boss sends out a spreadsheet listing our data entry errors for the previous day. All five of us download the sheet, make our edits, and send it back. She then opens each one individually, copies the parts she needs, and pastes it to her master copy. Our company has blocked Google Documents and requires us to use SharePoint; but my boss doesn't know how to set it up.
- Each have the errors sheet on our desktops, make our changes, and then her master copy on the SharePoint would update from our updates?
- Each have our own errors sheet on SharePoint (as well as her master copy) and pull the data from ours to hers within the same folder in a Document Library?
- Each have our own errors sheet on SharePoint, and her master copy would be on her desktop, updating from our SharePoint workbooks?
I've been reading about SharePoint for about 3 hours this evening, and I honestly can't find anyone describing a scenario this simple. If this is possible, just let me know and I'll get right on it!
P.S. I've made workbooks that refer to each other on a networked drive before, I'm hoping there's a way to just "refer" to SharePoint cells the same way, but I gather it's not that simple.