dancingdaisy2
New Member
- Joined
- Oct 27, 2018
- Messages
- 2
I have a spreadsheet that on the first sheet shows a list of classes down the right column and a list of instructors across the top row. X's are placed in the corresponding cell for instructors that are qualified to teach that class.
Second sheet has a table of classes, instructors and their training progress (it is a three-step process to become qualified to teach each class). This is used to show reports of how many instructors are in what phase of training for particular classes.
My question is if there is any way to link the cell with the X so that if you double click it will pull up the corresponding record of training progress for that individual instructor and class from the 2nd spreadsheet. Previously this has just been tracked using comment boxes on the cells, and I'm wondering if there is a way to simplify so the same data doesn't have to be recorded in both places. My initial thought was to create a form for each cell that the data could be entered in to and would populate in the table on sheet 2, but I'm still pretty new to the more advanced working of excel and have not been successful in making this happen.
Thanks in advance for your suggestions!
Cora
Second sheet has a table of classes, instructors and their training progress (it is a three-step process to become qualified to teach each class). This is used to show reports of how many instructors are in what phase of training for particular classes.
My question is if there is any way to link the cell with the X so that if you double click it will pull up the corresponding record of training progress for that individual instructor and class from the 2nd spreadsheet. Previously this has just been tracked using comment boxes on the cells, and I'm wondering if there is a way to simplify so the same data doesn't have to be recorded in both places. My initial thought was to create a form for each cell that the data could be entered in to and would populate in the table on sheet 2, but I'm still pretty new to the more advanced working of excel and have not been successful in making this happen.
Thanks in advance for your suggestions!
Cora