1. JamesHuds's Avatar
    Hello, I am part of a society that has many members throughout the uk who each need to submit an application at the end of each month.

    There are a dozen or so "branches" throughout the uk each with someone in charge, the LO, and dozens of members.

    Would it be possible with one drive to have each branch member be able to submit this excel form so that their relevant LO can see them? and then for the LO to be able to send parts of that data to another sheet that a central figure head can view?

    Only the LO of the branch should be able to view there members submission, and only this one main person should be able to see all of the submissions and the collated information sent by the LO?

    Is this possible? if so what would be required, accounts etc.
    03-29-2017 11:18 AM
  2. Steve van Ommen's Avatar
    YES
    1.every member needs to sign up for a OneDrive account
    2. Members create or upload their Excel doc to their account
    3. Members use the sharing button to obtain the viewing or editing link which they then email to their LO (with the option of a link expiry date)
    4. LO extracts the relevant data from all members into a new Excel. They obtain the sharing link and email onto CEO
    Ps there may be some Excel operations that automate the extraction process (using macros perhaps). That might be a question for https://www.excelforum.com/
    03-30-2017 06:57 AM
  3. Timbre70's Avatar
    Use google form.☺
    03-30-2017 08:25 AM

Similar Threads

  1. Nuvision TM800W610L Xbox Streaming Lags When HDMI Is Connected
    By Joshua Jackson in forum General Desktop, Laptop & Tablet Discussion
    Replies: 2
    Last Post: 04-10-2017, 11:27 AM
  2. Best Keyboards for Microsoft Surface
    By WindowsCentral.com in forum Windows Central News Discussion
    Replies: 0
    Last Post: 03-29-2017, 11:10 AM
  3. Samsung 'DeX' is Continuum for the Galaxy S8 — with support from Microsoft
    By WindowsCentral.com in forum Windows Central News Discussion
    Replies: 0
    Last Post: 03-29-2017, 11:10 AM
LINK TO POST COPIED TO CLIPBOARD