Matching people to skills.

[NigelG]

Hello, Apart from being a casual user of Excel, using a Forum is als
new so, if you feel I have posted this query in the wrong place pleas
advise. Thanks.

A group of us (75 people) volunteer FOC to marshal and support moto
events - racing, rallying etc. As a group, we have a number of differen
skills (50 approx) - fire fighting, cutting, electrical, mechanical et
at 3 different levels of experience - beginner, intermediate an
advanced. We group these skills together into 'packages' e.g. ‘Rescue
includes 4 skills some of which are also used in other ‘packages’ So
down my left column I have 75 people and across the top line I have 2
'Packages' with about 5 skills in each one - I have a separate colum
for each skill which I hide or unhide using??? I think its calle
grouping i.e. I click the + above the Heading and the other column
appear – technical explanation not great!

Ok, now my problem - when a person moves from beginner to semi skille
in say fire fighting and I update their individual record, I would lik
Excel to automatically update all the ‘packages' that this skill i
included in. i.e. instead of me having to open up each package and the
update the ‘skill’. Or, do I need to use Database instead.?

If the above doesn’t make sense please tell me and I will try harder
Thank you for your help, Nige

 

[Spencer101]

Hello, Apart from being a casual user of Excel, using a Forum is als
new so, if you feel I have posted this query in the wrong place pleas
advise. Thanks.

A group of us (75 people) volunteer FOC to marshal and support moto
events - racing, rallying etc. As a group, we have a number of differen
skills (50 approx) - fire fighting, cutting, electrical, mechanical et
at 3 different levels of experience - beginner, intermediate an
advanced. We group these skills together into 'packages' e.g. ‘Rescue
includes 4 skills some of which are also used in other ‘packages’ So
down my left column I have 75 people and across the top line I have 2
'Packages' with about 5 skills in each one - I have a separate colum
for each skill which I hide or unhide using??? I think its calle
grouping i.e. I click the + above the Heading and the other column
appear – technical explanation not great!

Ok, now my problem - when a person moves from beginner to semi skille
in say fire fighting and I update their individual record, I would lik
Excel to automatically update all the ‘packages' that this skill i
included in. i.e. instead of me having to open up each package and the
update the ‘skill’. Or, do I need to use Database instead.?

If the above doesn’t make sense please tell me and I will try harder
Thank you for your help, Nigel

Hi Nigel,

I think it makes sense but would be far easier to help out if we coul
see an example workbook.

Feel free to anonymise it by just turning them into "name 1", "name 2
etc

 

[NigelG]

Hi Nigel,

I think it makes sense but would be far easier to help out if we coul
see an example workbook.

Feel free to anonymise it by just turning them into "name 1", "name 2
etc.

Hi Spencer, Firstly, many thanks for taking the trouble to reply, muc
appreciated. Next, I am confused - as suggested I have just trie
uploading a stripped down version of the workbook but xls files are no
accepted according to the 'manage attachment'. Am I doing somethin
wrong?! Or do I need to convert the workbook into a word doc first?
Thanks
Nige

 

[Living the Dream]

Hi Spencer, Firstly, many thanks for taking the trouble to reply, much
appreciated. Next, I am confused - as suggested I have just tried
uploading a stripped down version of the workbook but xls files are not
accepted according to the 'manage attachment'. Am I doing something
wrong?! Or do I need to convert the workbook into a word doc first?
Thanks
Nigel

Hi Nigel

You have to upload it to a File Sharing site such as ExcelBanter or
similar site. You cannot attached files in NG's.

Cheers
Mick.