• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 46
  • Last Modified:

Excel 2007 - Auto Populate fields based on Cell Entry

Attached is a spreadsheet with notes.

Selections made by Department Heads on this spreadsheet are used to setup an employee's access to server data.  I'd like to make their job easier by auto-populating checkboxes based on an employee's status.  

For instance, a Service Technician's access to data would be different than a Service Manager's access to data.  I'd like the Department Head to simply choose either the Service Technician checkbox or the Service Manager checkbox and have the proper checkboxes for access automatically get checked.

Employment categories are listed on the spreadsheet along with more notes concerning what I'm trying to accomplish.

I just don't know the best method to do so.  "IF" statements look like they'd get too complicated to use.

Please advise.Test.xlsx
1 Solution
Ejgil HedegaardCommented:
Try attached
Accept macros on open.
Set a category and press the button "Set Check Boxes".
I have only set the values for Service Technician and Administration.

The definitions are on the sheet "CheckBox Assignment".
You can hide it.
The category names are in row 2 with the corresponding check box names in row 1.
And the access list in columns B:D, with the corresponding check box names in column A.
Set an "x" or something else if the check box must be used for the category.
Grey rows are the header lines without check box.
The cells are yellow, and turn green when you mark.
You can filter on colours, to make it easier to copy.
For Administration I have filtered on yellow, put an x in the first cell, and copied that down.

The access list on assignment sheet, is in the same order, and in the same rows as on the selection sheet TEST.
The checkbox names in column A and row 1 are generated by the macro MakeCheckBoxList.
Position is the row, so if the selection sheet setup is changed, a similar change must be done on the assignment sheet.
baleman2Author Commented:
My Gosh - this is PERFECT!!!!!  I would never have thought of this.  Thanks so much!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now