LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do you validate a list with more than one column

hi, how can one create a list with multiple rows so when you select a row it
posts all the entries in list (maybe 5 rows of corresponding data to that
list header). It brings up an error saying that you can use only one row or
delimited text. An example being selecting a person ie the main item in the
list and then all the columns of data responding to that person size, eye
colour, favourite food etc coming up automatically in the adjacent cells...

Thanks

 
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
validate duplicate entry in a column wangan Excel Discussion (Misc queries) 4 June 5th 07 01:38 PM
How to validate list data from a different workbook Tim Excel Discussion (Misc queries) 2 August 17th 06 02:00 PM
converted a column to List yet wants to Validate as well tikchye_oldLearner57 Excel Discussion (Misc queries) 2 July 17th 06 04:50 PM
How to validate data in already list dropdown validated. Rao Ratan Singh Excel Discussion (Misc queries) 2 June 14th 05 01:32 PM
validate data from list without picklist Tara Keane Excel Discussion (Misc queries) 1 January 27th 05 03:37 PM


All times are GMT +1. The time now is 03:50 PM.

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"