Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
luke013
 
Posts: n/a
Default HOW DO I CREATE LISTS WITH CELL REFERANCE RULES


  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

I'm not sure what you want to do. If you're trying to document data
validation that's been applied, there's code he

http://www.contextures.com/xlDataVal09.html

If that's not it, perhaps you could provide more details, and someone
may be able to help.

luke013 wrote:

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3   Report Post  
luke013
 
Posts: n/a
Default



"Debra Dalgleish" wrote:

I'm not sure what you want to do. If you're trying to document data
validation that's been applied, there's code he

http://www.contextures.com/xlDataVal09.html

If that's not it, perhaps you could provide more details, and someone
may be able to help.

luke013 wrote:
i have a spreadsheet with a validation list, and used vlookup to drag in other information that goes with that cell. i need a column that refers to one of the vlookup cells, bu gives a list of input options that match the information in the referance cell. is this possible??
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


  #4   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can create dependent data validation lists. There are instructions he

http://www.contextures.com/xlDataVal02.html

luke013 wrote:

"Debra Dalgleish" wrote:


I'm not sure what you want to do. If you're trying to document data
validation that's been applied, there's code he

http://www.contextures.com/xlDataVal09.html

If that's not it, perhaps you could provide more details, and someone
may be able to help.

luke013 wrote:
i have a spreadsheet with a validation list, and used vlookup to drag in other information that goes with that cell. i need a column that refers to one of the vlookup cells, bu gives a list of input options that match the information in the referance cell. is this possible??



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
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
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
How can I create a new line in a cell in Excel by hitting enter? Monica Excel Discussion (Misc queries) 4 July 1st 05 06:32 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Create a pick list to use to go to a text cell in Excel Pegita Excel Worksheet Functions 1 June 23rd 05 07:24 PM
how to create a variable column in cell reference Sampson Excel Worksheet Functions 3 February 21st 05 10:13 PM


All times are GMT +1. The time now is 05:39 PM.

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

About Us

"It's about Microsoft Excel"