Creating an automated checklist

%3CLINGO-SUB%20id%3D%22lingo-sub-2440507%22%20slang%3D%22en-US%22%3ECreating%20an%20automated%20checklist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2440507%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20to%20create%20a%20checklist%20where%20when%20a%20checkbox%20is%20selected%2C%20a%20list%20of%20items%20based%20on%20that%20selection%20will%20populate%20in%20another%20section%20of%20the%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20feel%20like%20there%20is%20a%20simple%20solution%20I%20just%20can't%20seem%20to%20figure%20it%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2440507%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%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2440977%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20an%20automated%20checklist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2440977%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1076956%22%20target%3D%22_blank%22%3E%40tbizzle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20simpler%20something%20looks%2C%20the%20harder%20it%20is.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20is%20an%20example%20in%20the%20inserted%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20am%20almost%20sure%20it%20is%20not%20what%20you%20want%20it%20to%20be.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI'm%20also%20not%20sure%20what%20you're%20trying%20to%20accomplish%20in%20the%20first%20place.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAre%20you%20sure%20what%20you%20want%20to%20do%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThen%20insert%20your%20preliminary%20work%20as%20a%20file%20(please%2C%20without%20sensitive%20data)%2C%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Eexplain%20your%20plans%20on%20the%20basis%20of%20this%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThis%20saves%20you%20a%20lot%20of%20work%20for%20the%20people%20you%20need%20help%20from.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThat%20means%20you%20could%20get%20a%20solution%20much%20faster.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThank%20you%20for%20your%20understanding%20and%20your%20time.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2441028%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20an%20automated%20checklist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2441028%22%20slang%3D%22en-US%22%3E%3CP%3E%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%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20please%20find%20a%20better%20idea%20of%20what%20I'm%20looking%20for.%26nbsp%3B%20When%20an%20item%20is%20check%20in%20sheet%201%2C%20I%20would%20like%20the%20list%20of%20items%20noted%20in%20Sheet%202%20to%20populate%20on%20the%20bottom%20of%20sheet%201.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am looking to create a checklist where when a checkbox is selected, a list of items based on that selection will populate in another section of the spreadsheet.

 

I feel like there is a simple solution I just can't seem to figure it out.

 

3 Replies

@tbizzle 

The simpler something looks, the harder it is.

Here is an example in the inserted file.

 

I am almost sure it is not what you want it to be.

I'm also not sure what you're trying to accomplish in the first place.

 

Are you sure what you want to do?

Then insert your preliminary work as a file (please, without sensitive data),

explain your plans on the basis of this file.

This saves you a lot of work for the people you need help from.

That means you could get a solution much faster.

 

Thank you for your understanding and your time.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community

 

@NikolinoDE 

 

Attached please find a better idea of what I'm looking for.  When an item is check in sheet 1, I would like the list of items noted in Sheet 2 to populate on the bottom of sheet 1. 

So as not to be misunderstood.
I am not an employee of Microsoft and in no way indirect.
I am a simple user, you know, who simply offered his knowledge and time voluntarily, with no guarantee.
Help to be helped. Helping people to help themselves is my motto.
I do not do any commissioned work and that for free. Help yes, but in your own project.

As helpers, we live from recognition, recognition that we get from other users when we have helped them.

Thank you for your understanding and patience

I wish you much success in your project

Nikolino
I know I don't know anything (Socrates)