I need to make an excel sheet for work that specifies damage to screens, and which ones are out of commission. I have check boxes next to each screen that is damaged. Once the screen is fixed they can uncheck the screen that is damaged. What I need is every time a screen is damaged it logs the information into another document so we can track which ones keep getting damaged. I don't want to have to type the information in this excel sheet and then in another document. Is there a way to link two so it automatically logs it in a different document? (Which screen was damaged, when it was damaged, cause).
It would also be nice if after the screen is fixed, when the check box is un-checked the information in the corresponding cells is cleared.
Any help would be greatly appreciated.
Bookmarks