Solved

Excel checklist within a cell (similar to the checklist per cell used in MS Project)

Posted on 2014-10-20
4
185 Views
Last Modified: 2014-10-22
I have a large spreadsheet with one column setup with Data Validation lookup to a list of 94 items. This list is color coded and I am struggling for a good way to have this list of 94 (per cell in column BT); part of the challenge is keeping the row height to 20px for ease of viewing.
So...I was thinking about keeping the cells small in column N, but have a drop-down display where any of the 94 validation items may be check marked.

Dear experts, I am not sure this is the best solution and am hoping you might have suggestions on how to do this. I am including the (scrubbed) file in question: please see column "BT" and the lookup to the 94 items on the CALC tab.

Thank you!
JohnD
Retail-Lab-status-example.xlsm
0
Comment
Question by:johndarby
  • 2
4 Comments
 
LVL 15

Expert Comment

by:David L. Hansen
Comment Utility
You can use a "named range" to define the 94 choices and then assign this named range to be the source for a dropdown box placed in the BD cells.
0
 
LVL 22

Expert Comment

by:Flyster
Comment Utility
Select BT3 and go to Data Validation. In Allow: select List, In Source:, enter "=Calc!N2:N95" (without quotes). Copy BT3 and past down to BT45. This will give you a drop-down for each cell. See attached.
Flyster
Retail-Lab-status-example.xlsm
0
 
LVL 1

Author Comment

by:johndarby
Comment Utility
Hey guys, thank you;  I already have the data validation working...my ask is if the drop down list could be configured with check boxes to multi-select items; I expect this is some VBA development
0
 
LVL 15

Accepted Solution

by:
David L. Hansen earned 500 total points
Comment Utility
How about using a ListBox with its multiselect property set to True.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Mac-based software for Excel 8 19
Slight Modification to Macro 2 14
Conditional format Excel Cell 3 14
TT Copy Formula 3 15
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now