ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW DO I CREATE LISTS WITH CELL REFERANCE RULES (https://www.excelbanter.com/excel-worksheet-functions/43081-how-do-i-create-lists-cell-referance-rules.html)

luke013

HOW DO I CREATE LISTS WITH CELL REFERANCE RULES
 


Debra Dalgleish

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


luke013



"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



Debra Dalgleish

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



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com