Employee competence overview - Macro help

%3CLINGO-SUB%20id%3D%22lingo-sub-1624796%22%20slang%3D%22en-US%22%3EEmployee%20competence%20overview%20-%20Macro%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1624796%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20learn%20how%20to%20build%20macros%20in%20Excel%2C%20since%20it%20will%20ease%20of%20my%20work%20a%20lot.%26nbsp%3BI%20have%20signed%20up%20for%20a%20VBA%20course%20late%20in%20september%2C%20but%20I%20have%20a%20task%20at%20my%20work%20right%20now%2C%20where%20I%20think%20I%20will%20have%20to%20use%20a%20macro%20to%20solve%20it%20most%20efficient.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20given%20the%20task%20to%20gather%2029%20Excel%20files%20(one%20for%20each%20employee)%20to%201%20overview%2C%20where%20it%20should%20be%20possible%20to%20look%20up%20a%20competence%2C%20and%20then%20a%20list%20of%20all%20the%20employees%20and%20the%20included%20level%20of%20the%20chosen%20competence%20should%20occur.%3C%2FP%3E%3CP%3EI%20have%20thought%20of%20one%20fixed%20column%20with%20employee%20names%20and%20then%20one%20column%20named%20%22Current%20Level%22%2C%20where%20the%20data%20will%20change%20depending%20on%20which%20competence%20is%20looked%20up.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20employees%20are%20from%20three%20different%20countries%2C%20so%20the%20files%20are%20placed%20in%20three%20different%20folders.%20The%20%22Master-file%22%20should%20be%20able%20to%20gather%20data%20from%20all%20of%20the%20three%20folders.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20any%20of%20you%20know%20where%20I%20can%20find%20Youtube%20tutorials%20or%20anything%20else%2C%20which%20can%20help%20me%20start%20up%20on%20this%20project%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely%2C%20Nicoline%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1624796%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi all, 

 

I want to learn how to build macros in Excel, since it will ease of my work a lot. I have signed up for a VBA course late in september, but I have a task at my work right now, where I think I will have to use a macro to solve it most efficient. 

 

I have been given the task to gather 29 Excel files (one for each employee) to 1 overview, where it should be possible to look up a competence, and then a list of all the employees and the included level of the chosen competence should occur.

I have thought of one fixed column with employee names and then one column named "Current Level", where the data will change depending on which competence is looked up. 

The employees are from three different countries, so the files are placed in three different folders. The "Master-file" should be able to gather data from all of the three folders. 

 

Do any of you know where I can find Youtube tutorials or anything else, which can help me start up on this project?

 

Sincerely, Nicoline

 

0 Replies