Create new cells based on values present in other Sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-3431161%22%20slang%3D%22en-US%22%3ECreate%20new%20cells%20based%20on%20values%20present%20in%20other%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3431161%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20dont%20know%20how%20to%20explain%20this%20so%20hopefully%20this%20makes%20some%20sense.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20a%20table%20and%20one%20column%20in%20the%20table%20is%20the%20person%20responsible%20for%20taking%20an%20action.%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20another%20sheet%20i%20want%20to%20then%20create%20a%20summary%2C%20showing%20how%20many%20items%20each%20person%20has%20attributed%20to%20them.%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20Column%20A%26nbsp%3B%20row%201%20would%20be%20Person%20A%20Name%20and%20Column%20B%20Row%201%20Would%20be%20a%20count%20of%20the%20items%20attributed%20to%20them.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20a%20new%20person%20has%20an%20item%20attributed%20to%20them%2C%20Column%20A%20would%20automatically%20then%20have%20Person%20B%20name%20added%20to%20Row%202%20and%20their%20Item%20Count%20in%20Column%20B%20Row%202.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20ideas.%26nbsp%3B%3C%2FP%3E%3CP%3EThankyou.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3431161%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3432537%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20new%20cells%20based%20on%20values%20present%20in%20other%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3432537%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1402444%22%20target%3D%22_blank%22%3E%40JoshSmith89%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EWith%20your%20permission%2C%20if%20I%20may%20recommend%2C%20it%20would%20be%20beneficial%20to%20know%20the%20Excel%20version%2C%20operating%20system%20and%20storage%20medium.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EA%20file%20(without%20sensitive%20data)%20or%20a%20photo%20so%20you%20can%20come%20up%20with%20a%20solution%20much%20faster%20and%20we%20don't%20have%20to%20waste%20time%20guessing.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EWin-win%20for%20both%20%3A).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3435879%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20new%20cells%20based%20on%20values%20present%20in%20other%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3435879%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%20LTSC%20Professional%20Plus%202021%20on%20windows%2010.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20sheet%20to%20track%20defects%20raised%20during%20projects.%20When%20a%20defect%20is%20found%20it%20is%20allocated%20to%20a%20person.%20This%20person's%20initials%20will%20be%20typed%20in%20not%20selected%20from%20a%20list%20as%20any%20person%20could%20potentially%20be%20added.%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20below%20example%20of%205%20allocations%2C%20with%204%20unique%20individuals%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JoshSmith89_0-1653602200559.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22JoshSmith89_0-1653602200559.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F375592i8FFB7DDA102A2930%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JoshSmith89_0-1653602200559.png%22%20alt%3D%22JoshSmith89_0-1653602200559.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20then%20have%20a%20summary%20page%2C%20where%20i%20would%20like%20to%20show%20each%20person%20who%20has%20an%20action%20allocated%2C%20so%20i%20can%20provide%20statistics%20on%20how%20many%20allocations%20each%20person%20has%2C%20as%20well%20as%20how%20many%20items%20they%20have%20completed%20and%20how%20many%20items%20are%20outstanding.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JoshSmith89_1-1653602262233.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22JoshSmith89_1-1653602262233.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F375593i3BB5A1BE6A5B8E1D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JoshSmith89_1-1653602262233.png%22%20alt%3D%22JoshSmith89_1-1653602262233.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20basically%20im%20trying%20to%20workout%20how%20to%20automatically%20populate%20this%20table%20with%20each%20unique%20person%20and%20their%20applicable%20counts.%20Each%20time%20a%20new%20person%20is%20added%20to%20the%20%22Allocated%20To%22%20column%20of%20the%20initial%20table%20they%20should%20be%20automatically%20added%20to%20the%20%22Action%20Responsibilites%22%20column%20of%20the%20summary%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, 

I dont know how to explain this so hopefully this makes some sense. 

I would like to create a table and one column in the table is the person responsible for taking an action. 

On another sheet i want to then create a summary, showing how many items each person has attributed to them. 

Basically Column A  row 1 would be Person A Name and Column B Row 1 Would be a count of the items attributed to them. 

If a new person has an item attributed to them, Column A would automatically then have Person B name added to Row 2 and their Item Count in Column B Row 2. 

 

Does anyone have any ideas. 

Thankyou. 

2 Replies

@JoshSmith89 

 

With your permission, if I may recommend, it would be beneficial to know the Excel version, operating system and storage medium.

A file (without sensitive data) or a photo so you can come up with a solution much faster and we don't have to waste time guessing. Win-win for both :).

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

Hello @NikolinoDE 

I am using Excel LTSC Professional Plus 2021 on windows 10. 

I am creating a sheet to track defects raised during projects. When a defect is found it is allocated to a person. This person's initials will be typed in not selected from a list as any person could potentially be added. 

See below example of 5 allocations, with 4 unique individuals

 

JoshSmith89_0-1653602200559.png

 

 

I then have a summary page, where i would like to show each person who has an action allocated, so i can provide statistics on how many allocations each person has, as well as how many items they have completed and how many items are outstanding. 

 

JoshSmith89_1-1653602262233.png

 

So basically im trying to workout how to automatically populate this table with each unique person and their applicable counts. Each time a new person is added to the "Allocated To" column of the initial table they should be automatically added to the "Action Responsibilites" column of the summary table.

 

Hope this helps

Thanks