W
Weatherall Ian D.
Hi Folks,
I have 2 excel files, the first is a list of associates and the training
modules they have passed, so 1 person can have passed more modules than
another. There is a list modules that all the associates must pass, this is
in another worksheet with associate names in column A and the core modules
are listed from left to right, once 1 module has been passed a tick is put
under that particular module.
I would like to find some way of comparing the 2 worksheets so the list of
core modules in the second sheet inserts a tick in the relevant cell, if the
module shows up in the first sheet.
I dont know where to start with this?
Regards,
Ian
I have 2 excel files, the first is a list of associates and the training
modules they have passed, so 1 person can have passed more modules than
another. There is a list modules that all the associates must pass, this is
in another worksheet with associate names in column A and the core modules
are listed from left to right, once 1 module has been passed a tick is put
under that particular module.
I would like to find some way of comparing the 2 worksheets so the list of
core modules in the second sheet inserts a tick in the relevant cell, if the
module shows up in the first sheet.
I dont know where to start with this?
Regards,
Ian