Hi All,
I am pretty new to the VBA environment and have this report which I think can easily be processed using a macro.
The data contains names of various people and their skill level as given below:
Name Resource 01 Resource 02
Email Email Email
Skill 01 Mastery
Skill 02 Foundation Mastery
Skill 03 Advanced
Skill 04 Advanced
Skill 05 Foundation
Skill 06 Advanced Advanced
Skill 07 Advanced Foundation
Skill 08 Advanced
Skill 09 Foundation
Skill 10 Mastery
I would like to combine the skill name (Skill 01, Skill 02...) with the level (Mastery, Advanced...) for each resource column (except blanks) so that the data looks as below:
Step 1:
Name Resource 01 Resource 02
Email Email Email
Skill 01 Mastery Skill 01
Skill 02 Foundation Skill 02 Mastery Skill 02
Skill 03 Advanced Skill 03
Skill 04 Advanced Skill 04
Skill 05 Foundation Skill 05
Skill 06 Advanced Skill 06 Advanced Skill 06
Skill 07 Advanced Skill 07 Foundation Skill 07
Skill 08 Advanced Skill 08
Skill 09 Foundation Skill 09
Skill 10 Mastery Skill 10
Step 2: Final and most important step is to create a new word document for each resource (preferably the resource name as the file name)
so the word doc for Resource 01 will look as follows:
Resource 01
Mastery Skill 01
Advanced Skill 04
Advanced Skill 06
Advanced Skill 07
Foundation Skill 02
There are 100s of resources with 100s of skill levels listed against them. So you can imagine the amount of time a macro can save in combining and creating these documents.
Any help regarding will be hugely beneficial!
Bookmarks