Tommy Teapot
Prominent Member
Hi,
I’m trying to create a spread sheet using excel, its main purpose is to record dates when staff attended training. The left hand side is the list of staff and along the top has the different training courses. The main table contains dates when staff attended a training course (dd/mm/yy). The main purpose of this table is to record dates of when training has been attended over the years and when they’re next due again etc. At present I’m listing previous dates using the comments box within the cells, each time someone attends a training course I add that date to the comments box, I then change the date in the cell to indicate when they’re next due their training Ie if training was attended 1/1/16, the cell would read 1/1/17.
I was hoping to get some advice on laying this table out better, mainly another way of displaying the previous dates of training attended (the comments box doesn’t look great & could easily be deleted by mistake). Ideally I would like the cells to indicate the next due date, then, when you click the cell it would reveal a drop down list (non-selectable) of dates previously attended. I’m not quite sure if it can be done that way? I need something that’s easily updated & maintained so my colleague can update the table when I’m not here.
I appreciate any help.
Thanks!
I’m trying to create a spread sheet using excel, its main purpose is to record dates when staff attended training. The left hand side is the list of staff and along the top has the different training courses. The main table contains dates when staff attended a training course (dd/mm/yy). The main purpose of this table is to record dates of when training has been attended over the years and when they’re next due again etc. At present I’m listing previous dates using the comments box within the cells, each time someone attends a training course I add that date to the comments box, I then change the date in the cell to indicate when they’re next due their training Ie if training was attended 1/1/16, the cell would read 1/1/17.
I was hoping to get some advice on laying this table out better, mainly another way of displaying the previous dates of training attended (the comments box doesn’t look great & could easily be deleted by mistake). Ideally I would like the cells to indicate the next due date, then, when you click the cell it would reveal a drop down list (non-selectable) of dates previously attended. I’m not quite sure if it can be done that way? I need something that’s easily updated & maintained so my colleague can update the table when I’m not here.
I appreciate any help.
Thanks!