Dynamic Skills Matrix

[AngleseyExcel]

I have recently downloaded the Dynamic Skills Matrix from Excel for Freelancers. It's a nifty file, but for my needs i want it to work for 60 skills, not the 20 it's built with.

Can anyone work out how to get it to work for 60 skills ?

Editing the VBA code is way over my head.

Any help would be greatly appreciated. The link to the file is below the screenshot.

Dynamic Skills Matrix - Excel File

 

[Kaper]

The file has restricted acces rights - not downloadable.

BTW. I've checked 350 Workbook Package – Excel For Freelancers and indeed it seems that you (or we ) can change the code/layout of the workbook, as: "Every workbook in my pack is open, unlocked, and ready for you. No restrictions, no passwords – just pure flexibility to customize and innovate."

 

[AngleseyExcel]

Apologies, I did forget to change the access rights. It's now downloadable.

 

[AngleseyExcel]

The file has restricted acces rights - not downloadable.

BTW. I've checked 350 Workbook Package – Excel For Freelancers and indeed it seems that you (or we ) can change the code/layout of the workbook, as: "Every workbook in my pack is open, unlocked, and ready for you. No restrictions, no passwords – just pure flexibility to customize and innovate."

Hi, apologies, when i created the link to the file, i did indeed forget to change the share settings. It's now downloadable. Is it something that you think you could help with ?

 

[Kaper]

I opened the file and checked the structure and the code.
And have bad news: It will be a long and tedious work to change it.

Adding skills to a list is easy. It is in Admin sheet and is dynamic. But to have 60 active columns in Skills matrix sheet will require a lot of changes in code. A code which is neither commented (except of meaningfull variables), nor dynamic (relating actions not to specific cells but to cells with specific content or at least to some constants defined in a code). So everywhere when for instance column AN is mentioned, one needs to change it to CA and so on. ANd the changes shall go in parallel with formulas and formatting/layout adjustment

It can be done, as the total code is some 500 lines: 2 modules with ~200 lines and code in sheet module with ~100 lines. But it means probably something like 5 hours of work or probably (with reasonable testing) more.

So I am giving up. May be author would be open to adjust his code. He is probably living from excel file preparation and consulting.