LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 12
Default Lists for List Validation

I am trying to use validation by list on a sheet in a workbook.

As the sheet it appears on is designed as a customer interface, and the valid datalist is already on another sheet I would like to be able to set the list source to the other sheet. I have tried to do this several times but the validation selection boxes seems to reject it everytime I try to link to the other sheet.

Is there a way to set this please.
Sheet name Catologue data has the list of data in cells A2:A8
I want to use the list validation on a sheet called Customer Lookup
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data validation with validation lists and combo boxs Keith Excel Discussion (Misc queries) 1 October 12th 06 11:08 AM
Validation lists Renee Major Excel Discussion (Misc queries) 1 April 25th 06 12:02 AM
Using Lists/Validation Bruce Excel Discussion (Misc queries) 1 March 30th 06 05:28 AM
Data Validation lists - entering value not in list rgarber50 Excel Discussion (Misc queries) 3 July 19th 05 08:35 PM
Adding entry to validation list without retyping all lists BB Excel Discussion (Misc queries) 2 June 14th 05 10:26 PM


All times are GMT +1. The time now is 03:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"