How can I improve the efficiency of my sheet?

We are using a sheet to track a number of different measures which will provide a baseline for Q4 2020. These measures are tracked for a month, with detail and a RAG status being provided by a number of different people once a week from October 9th - 30th.

At the moment, we have a separate column for each detail and RAG status, as seen in the picture below.

This is obviously not very efficient as each person will have to access the sheet, find the correct column and enter their data.

We have discussed the possible use of update requests or reports but are interested to hear if anyone else has encountered a similar problem and has an efficient solution?

Please let me know if you need more information.

Thank you.

Best Answer


  • That's a good idea, I will give it a go! Thanks a lot David.

  • David Tutwiler
    David Tutwiler Overachievers Alumni

    No problem. Hope it works out.