How to create a spreadsheet w/notes that I can add new data to without erasing any notes

Question

I am trying to create an excel schedule to help me track production at my workplace. I have a report I can pull daily that collects information from our ordering system. I would like to add that report to a dashboard, and be able to add notes to it, then add new data the next day (not adding any duplicate data) without losing the notes that I had entered on the previous day. I have an old sheet written like this, however I do not have the coding knowledge to properly read it and make amendments to it to collect the new information I am looking for. If anyone has any suggestions, I would greatly appreciate them, thanks!

Answer 1

Hi @Jeremy McKean,

Thank you for posting your question in the Microsoft Q&A forum.

For further assistance, can you share some screenshots of the data worksheet and also your expected results so I can clearly understand the current structure of your file and your request to give the most appropriate guidance.

Please understand that the initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution. 

Thank you for your understanding and cooperation. I'm looking forward to your reply.