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
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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies