C
Connie
Dan, my first post and your response are buried so far
down in this newsgroup now, I thought I would bring this
forward. My post and your response are pasted below. My
question now is, I want this to apply to cells D16 to D57
and E16 to E57 on all three worksheets. I only mentioned
one because I thought I could drag a formula down, but
this one is different. I've fiddled around with it to see
if I could figure it out, but it's not working. How do I
get this now to cover the range of cells I want?
____________________
Subject: Re: A dilly of a question!
From: "Dan E" <[email protected]>
Sent: 11/7/2003 2:09:31 PM
Connie,
You will need to create a named range called Test
(anywhere in your workbook is fine).*
In Test put the formula:
=Sheet1!D16 & Sheet2!D16 & Sheet3!D16
Select Sheet1!D16 and from the menu choose
Data -> Validation then
Under the Settings tab choose Allow Custom and in
the Formula field put "=D16=Test" without quotes
Under the Error Alert tab enter a custom error
message if you choose or use excel's default.
Repeat for each sheet (2 and 3)
Then a user can only have 1 of either Sheet1!D16,
Sheet2!D16 or Sheet3!D16
* To create a named range from the menu select
Insert -> Name -> Define
Put in Test and set it to whichever cell you choose.
This allows the use of 1 cell in all data validation.
Dan E
down in this newsgroup now, I thought I would bring this
forward. My post and your response are pasted below. My
question now is, I want this to apply to cells D16 to D57
and E16 to E57 on all three worksheets. I only mentioned
one because I thought I could drag a formula down, but
this one is different. I've fiddled around with it to see
if I could figure it out, but it's not working. How do I
get this now to cover the range of cells I want?
____________________
Subject: Re: A dilly of a question!
From: "Dan E" <[email protected]>
Sent: 11/7/2003 2:09:31 PM
Connie,
You will need to create a named range called Test
(anywhere in your workbook is fine).*
In Test put the formula:
=Sheet1!D16 & Sheet2!D16 & Sheet3!D16
Select Sheet1!D16 and from the menu choose
Data -> Validation then
Under the Settings tab choose Allow Custom and in
the Formula field put "=D16=Test" without quotes
Under the Error Alert tab enter a custom error
message if you choose or use excel's default.
Repeat for each sheet (2 and 3)
Then a user can only have 1 of either Sheet1!D16,
Sheet2!D16 or Sheet3!D16
* To create a named range from the menu select
Insert -> Name -> Define
Put in Test and set it to whichever cell you choose.
This allows the use of 1 cell in all data validation.
Dan E