Tracking multiple vendors

Question

I have the task to create in excel a way to track multiple vendors in multiple assignment site on a daily basis, which will be over 20 each. This spreadsheet will need to track the cost of the individual assignment as well. Reports will need to reflect dates assigned, dates completed, projected total cost and actual total cost.

Is there a way to create and manage in excel other than starting with the basic spreadsheet and creating it all from scratch, adding formulas in, as needed?

thank you for any assistance you may provide,

Karen

Answer 1

Hi @Karen Fallen ,
In my opinion, I suggest you try these methods:

1. Surveys in Excel: https://support.microsoft.com/en-us/office/surveys-in-excel-hosted-on-the-web-5fafd054-19f8-474c-97ec-b606fcda0ff9
2. Collaborate on Excel workbooks at the same time with co-authoring: https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.