I am keeping track of employee training using different excel spreadsheets within my workbook, and I need some help!
I have a master worksheet with all employees names, alphabetized, as my farthest left column, so each employee has their own row. The rest of the columns are the different classes. when they take a class, they get a checkbox in the corresponding column for the class they have taken. Make sense?
Here is my issue. I also have spreadsheets for each individual class, where I keep track of registration and more detailed information like different tables for each date the class was offered, and who was registered for which date. That way I can see not only what class someone took (on the master spreadsheet), but I can go to the individual class tab, and see, oh they took it the third time we offered it in October.
So what is taking me A LOT of time, is checking boxes for completion on both the individual class tab, and the master list. I know how to link rows and columns between spreadsheets, but only if the values in each cell stay exactly the same. When the names are alphabetized on the master list, the linking would have to find the matching name (row) and link it to the right class(column).....so I would only have to do it on the individual tabs, and it would copy over to the master.
IS THIS POSSIBLE??
I have a master worksheet with all employees names, alphabetized, as my farthest left column, so each employee has their own row. The rest of the columns are the different classes. when they take a class, they get a checkbox in the corresponding column for the class they have taken. Make sense?
Here is my issue. I also have spreadsheets for each individual class, where I keep track of registration and more detailed information like different tables for each date the class was offered, and who was registered for which date. That way I can see not only what class someone took (on the master spreadsheet), but I can go to the individual class tab, and see, oh they took it the third time we offered it in October.
So what is taking me A LOT of time, is checking boxes for completion on both the individual class tab, and the master list. I know how to link rows and columns between spreadsheets, but only if the values in each cell stay exactly the same. When the names are alphabetized on the master list, the linking would have to find the matching name (row) and link it to the right class(column).....so I would only have to do it on the individual tabs, and it would copy over to the master.
IS THIS POSSIBLE??
Last edited: