Home

Combining data from multiple sheets to one master sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-858489%22%20slang%3D%22en-US%22%3ECombining%20data%20from%20multiple%20sheets%20to%20one%20master%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858489%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI%20am%20not%20great%20at%20Excel%20but%20would%20like%20to%20learn%20more%20and%20i%20have%20a%20specific%20goal%20to%20achieve.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20workbook%20with%2010%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%201%20is%20the%20master%20sheet%20and%20is%20a%20skills%20matrix%20with%20options%20along%20the%20columns%20and%20rows.%3C%2FP%3E%3CP%3ESheets%202%20to%2010%20are%20people%20who%20have%20ticked%20the%20boxes%20(ticking%20is%20done%20with%20VB%20script%20that%20allows%20them%20to%20double%20click%20the%20cells)%20with%20their%20corresponding%20skill%20sets.%3C%2FP%3E%3CP%3ESo%20cell%20G10%20may%20be%20column%20technology%20and%20row%20installation%20which%20means%20this%20person%20has%20installation%20skills%20in%20technology.%20Column%20C3%20may%20be%20marketing%20and%20row%20social%20media%20so%20this%20person%20has%20marketing%20skills%20in%20social%20media%2C%20and%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20i%20want%20to%20do%20is%20have%20Sheet%201%20examine%20all%20the%20sheets%202%20to%2010%20and%20identify%20where%20people%20have%20marked%20their%20skills%20and%20then%20combine%20this%20data%20and%20show%20a%20tick%20in%20the%20relevant%20cell.%20If%20you%20hover%20over%20the%20cell%20display%20a%20list%20of%20all%20the%20people%20who%20have%20this%20skill%20for%20easy%20lookup.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20would%20i%20achieve%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-858489%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%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
Highlighted
FocusAndrew
Visitor

Hi All,

I am not great at Excel but would like to learn more and i have a specific goal to achieve.

 

I have a workbook with 10 sheets.

 

Sheet 1 is the master sheet and is a skills matrix with options along the columns and rows.

Sheets 2 to 10 are people who have ticked the boxes (ticking is done with VB script that allows them to double click the cells) with their corresponding skill sets.

So cell G10 may be column technology and row installation which means this person has installation skills in technology. Column C3 may be marketing and row social media so this person has marketing skills in social media, and so on.

 

What i want to do is have Sheet 1 examine all the sheets 2 to 10 and identify where people have marked their skills and then combine this data and show a tick in the relevant cell. If you hover over the cell display a list of all the people who have this skill for easy lookup.

 

How would i achieve this?

Related Conversations