Data Validation issues...

[Snowmonster]

Hi Everyone...

I am trying to find a way of putting a dependant cell (with a formula in it to populate it), and having a drop down list appear in the cell next to it, if and only if the dependant cell is not blank...

Any ideas...

Cheers, Snowmonster

 

[tara_922]

Hiya!

Not that I can necessarily help, I'm self-taught at best, but there are a couple things I would want to know.

First, what version of excel are you using?
Second, if the box next to the dependent drop down list is not blank, what would the value be (i.e. alpha, numerical, or alphanumerical)

Thanks,
Tara

P.S. http://www.brighthub.com/computing/windows-platform/articles/25709.aspx

 

[Snowmonster]

Hi Tara...

The cell next to the drop down has a formula in it that places a date (format: 1st, 2nd, etc)...
I am using Office 10...

Thanks for your reply...

Snowmonster

 

[tara_922]

Hiya,

okay, I think i've figured it out...

What I did is i added a column with the data I wanted in the drop down list. I then selected all the cells in that column with data and right clicked selecting "name range". I named the range Housekeepers. In cell G3 (one I picked at random) I went to data validation and selected list and in the source box I put the formula below

the formula is
=IF(ISBLANK(F3),"",Housekeepers)

I hope this helps.

Have a great day!

Tara

P.S. This is my 100th post!

 

[T. Valko]

This is my 100th post!

 

[tara_922]

Thanks T Valko...it's especially meaningful to me because this is the first time I've been able to help somebody else instead of asking for help for myself

 

[Snowmonster]

Hiya,

okay, I think i've figured it out...

What I did is i added a column with the data I wanted in the drop down list. I then selected all the cells in that column with data and right clicked selecting "name range". I named the range Housekeepers. In cell G3 (one I picked at random) I went to data validation and selected list and in the source box I put the formula below

the formula is
=IF(ISBLANK(F3),"",Housekeepers)

I hope this helps.

Have a great day!

Tara

P.S. This is my 100th post!

Hi Tara...
Thanks for the reply, Happy 100th...
Sorry to say though, it didn't work on mine. I think the problem I have is that there is a formula in the dependant cell, and this is causing it to think it's populated...
I'll keep on looking...
Thanks again...
Snowmonster

 

[tara_922]

Hiya Snow,

There is a way around that, let me think about it and get back to you unless somebody else can reply first! Sorry it didn't work for you.

Tara

 

[tara_922]

Hiya Snow!

Can you try =IF(F3="","",Housekeepers)

Of course changing the cell and named range reference to what you need it to be.

Doing that has worked for me, so I'm keeping my fingers crossed.

Thanks,
Tara

P.S. Please reply if it doesn't work, we'll look into it more.

 

[Snowmonster]

Hi Tara...

I am afraid that didn't work either, I defo think it's because there is a formula in the dependant cell...

Thanks again...

Snowmonster