![]() |
HOW DO I CREATE LISTS WITH CELL REFERANCE RULES
|
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 |
"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 |
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