Data Validation

jayd77

New Member
Joined
Mar 25, 2003
Messages
18
Is it possible to do something like this (="*"&EmpListThur&"*") in a data validation. Currently it's not working.

EmpListThur is a list of all employees who can work Thursday.

EmpListThur has null values or blank cells so I can type anything into the schedule whether it is on the list or not. This is to my advantage because on some days a driver comes in early (ex: Smith in @6am ) and I can just put it right on the schedule with his name. However, this means that the person doing the schedule could type the employees name wrong(ex:Smit in @6am) and then the calculated hours for that employee would be off.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi, Jayd77,

Choose "list" in the validationbox and type
=EmpListThur in the sourcebox

kind regards,
Erik
 

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
I don't understand what you want the validation to show. What should the asterisks add to the validation?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
What exactlyis EmpListThur?

Is it a named range?

What exactly are you trying to do?
 

jayd77

New Member
Joined
Mar 25, 2003
Messages
18

ADVERTISEMENT

Sorry I edited the message as soon as I posted it realizing I left out some information

EmpListThur is column of employee names about 70 rows
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832

ADVERTISEMENT

jayd77,

What's the problem?
You asked a question, you recieved response. I think my solution can do what you wanted, but perhaps it was a misunderstanding.
Did you try it? What do you need more?

kind regards,
Erik
 

jayd77

New Member
Joined
Mar 25, 2003
Messages
18
Like I say, I edited the question as soon as I posted it. The responses I got did not solve the problem. Please reread the complete question.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
An example would help.
Also clearly explain what's missing in the responses would help.
 

jayd77

New Member
Joined
Mar 25, 2003
Messages
18
Thurs Fri Sat
shift 1 Smith Jones Lee
shift 2 6am Jones Lee Smith
shift 3 Lee Smith 6am Jones


employee list -different for each day of the week depending on who can work a particular day. Blank fields= employees who are off

Smith
Jones

Lee

Arnold


=EmpListThur allows me to enter any value into a cell whether it is in the
list or not because the blank fields are the result of an if statement "". If I alter the IF statement to make the fields have some arbitrary value "-" then the values I enter have to be within the list. Out of some 200 shifts only 4 or 5 employees need to come in early. If I leave the IF statement returning a value of "" for employees who are off I can then schedule an employee in early directly on the main schedule. There are many other ways I can handle this problem but, if I can figure out the proper data validation it would save a lot of hassle.
 

Forum statistics

Threads
1,147,677
Messages
5,742,566
Members
423,738
Latest member
AshleyKitsune

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top