Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change where validation should be?
I created a validaton, it should be in column b only upto the last row of
data in col a, and the amount of rows with data in col a will change all the time, what should I do? Do I have to delete and recreate the location every time, if so then how? thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change where validation should be?
Use a formula of
=OFFSET($A$1,,,COUNTA($A:$A),1) in the list formula of the DV. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mikeb" wrote in message ... I created a validaton, it should be in column b only upto the last row of data in col a, and the amount of rows with data in col a will change all the time, what should I do? Do I have to delete and recreate the location every time, if so then how? thanks in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change where validation should be?
Bob, what I'm trying to do is have validation list in column B consisting of
all the unique values in column A and if col A goes to row 100 col B goes to Row 100, the number of rows in col a changes. In my code I get the unique values and place them in another sheet, I now want to create a dynamic named range and use that for validation in col B. "Bob Phillips" wrote: Use a formula of =OFFSET($A$1,,,COUNTA($A:$A),1) in the list formula of the DV. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mikeb" wrote in message ... I created a validaton, it should be in column b only upto the last row of data in col a, and the amount of rows with data in col a will change all the time, what should I do? Do I have to delete and recreate the location every time, if so then how? thanks in advance! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change where validation should be?
Just use the formula that I provided to create the named range then.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mikeb" wrote in message ... Bob, what I'm trying to do is have validation list in column B consisting of all the unique values in column A and if col A goes to row 100 col B goes to Row 100, the number of rows in col a changes. In my code I get the unique values and place them in another sheet, I now want to create a dynamic named range and use that for validation in col B. "Bob Phillips" wrote: Use a formula of =OFFSET($A$1,,,COUNTA($A:$A),1) in the list formula of the DV. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mikeb" wrote in message ... I created a validaton, it should be in column b only upto the last row of data in col a, and the amount of rows with data in col a will change all the time, what should I do? Do I have to delete and recreate the location every time, if so then how? thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation list font change | Excel Discussion (Misc queries) | |||
How does Data Validation change with a formula change? | Excel Worksheet Functions | |||
change data validation | Excel Programming | |||
Add/Change Data validation list | Excel Programming | |||
change validation on protected sheet | Excel Programming |