If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

excel data validation

RustySpoon · 2006-11-03 16:19:24

How can you hack Excel to give you a drop down list (data validation) across the entire woorbook instead of the default which is just on each sheet? i.e. I need to have the same list of drop downs available on all the worksheets but just want to have the list on the first sheet. As defualt i need to copy the list to each…

03-11-2006 4:19pm

#1

RustySpoon

Registered Users, Registered Users 2 Posts: 420 ✭✭

Join Date: January 2005

Posts: 382

How can you hack Excel to give you a drop down list (data validation) across the entire woorbook instead of the default which is just on each sheet?

i.e.
I need to have the same list of drop downs available on all the worksheets but just want to have the list on the first sheet.
As defualt i need to copy the list to each sheet and setup the data validation on each cell.

Is there a way around this?

0

Comments

#2 03-11-2006 5:46pm

bbbbb

Registered Users, Registered Users 2 Posts: 738 ✭✭✭

Join Date: January 2004

Posts: 685

It would appear you can't do this. I tried:
- create list on sheet1
- go to sheet2 and select all
- data->validation
- allow list
- source, enter "=sheet1!a1:a3"
I get an error dialog:
"You may not use references to other worksheets or workbooks for Data Validation criteria."

0