Excel sheet project tracking / project changes
Curious question for my project managers out there. I use Excel for a lot of my projects but I am running into a lot of manual data entry.... so I am attempting to not make more work for myself but in saying this, one issue that keeps arising is tracking down changes / or changes that are made within the excel sheet and how to find them... Here is real life example.
**I work in door hardware sales**
Client calls me about Door 105. Well door 105 has had a lot of changes made to it, and after a while with many hands in the pot, it becomes a question of what was actually settled on for door 125. See screen clip of door 105 below
Is there a way or a good spot to make sure that I can look up or know all of the changes that are made with that specific Line item? I thought about making a tab down below for every door that I could go write notes on. I know I can add notes to individual cells.. but I am just looking for a better system or process that others have used or perfected.
Systems I have tried in past -
Separate notes tab to keep track of all phone / email conversations about project
Notes in cells
Cover page with notes
Excel on one drive - so I can track changes
Let me know what has worked for you guys!
[link] [comments]
Want to read more?
Check out the full article on the original site