Data Validation in MS Excel

[Turkish]

Greetings,

I have a worksheet (lets call it artistssheet) with a list of Artists in it... lets say the colum B looks like the following:

Artists
ATB
Chemical Brothers
Coldplay
Paul Oakenfold
Radiohead
REM
U2

I have another worksheet (CDs), where I want the user to put in the name of the artist a CD belongs to. However I need to validate it so that a user can only put in artist names from the artists listed at artistssheet.

I tried going through Data > Validation but since my data is another worksheet, I couldn't figure how to do it

Any help?

edit: doh, meant to post this in software forum, mods; move as necessary. thanks.

 

[DAM]

I recommend you move this to an Access DB in the long run you should be much safer and happier with your capabilities.

 

[minendo]

Open both workbooks and link them.

 

[Turkish]

Originally posted by: DAM
I recommend you move this to an Access DB in the long run you should be much safer and happier with your capabilities.

its just for a small project... i wont need it after its graded later this week so not much worried.

 

[Turkish]

Originally posted by: minendo
Open both workbooks and link them.

they are in the same workbook, just different worksheets

 

[CaseTragedy]

Originally posted by: Xiety
Greetings,

I have a worksheet (lets call it artistssheet) with a list of Artists in it... lets say the colum B looks like the following:

Artists
ATB
Chemical Brothers
Coldplay
Paul Oakenfold
Radiohead
REM
U2

I have another worksheet (CDs), where I want the user to put in the name of the artist a CD belongs to. However I need to validate it so that a user can only put in artist names from the artists listed at artistssheet.

I tried going through Data > Validation but since my data is another worksheet, I couldn't figure how to do it

Any help?

edit: doh, meant to post this in software forum, mods; move as necessary. thanks.

You can't use data validation on different worksheets/books.
But you can use it on a list of values.
Just turn your first sheet of artists into a list of values (insert > define > name).
Then set your data validation in your second sheet to 'list' (source: "=nameOfList").


-Case

 

[Turkish]

Originally posted by: CaseTragedy

Originally posted by: Xiety
Greetings,

I have a worksheet (lets call it artistssheet) with a list of Artists in it... lets say the colum B looks like the following:

Artists
ATB
Chemical Brothers
Coldplay
Paul Oakenfold
Radiohead
REM
U2

I have another worksheet (CDs), where I want the user to put in the name of the artist a CD belongs to. However I need to validate it so that a user can only put in artist names from the artists listed at artistssheet.

I tried going through Data > Validation but since my data is another worksheet, I couldn't figure how to do it

Any help?

edit: doh, meant to post this in software forum, mods; move as necessary. thanks.

You can't use data validation on different worksheets/books.
But you can use it on a list of values.
Just turn your first sheet of artists into a list of values (insert > define > name).
Then set your data validation in your second sheet to 'list' (source: "=nameOfList").


-Case

worked thank you